 Do you have a topic that you'd like discussed? We'd love to hear from you. Send us your idea for a blog topic.
|
|
|
|
|
|
|
Author: |
StevenFeuersteinTW |
Created: |
Thursday, October 26, 2006 10:47 AM |
 |
|
Life’s short and there’s more to it than coding. How can we change the way we write our programs so that we can spend less time in front of a screen and more time with family, friends and planet earth? Visit my blog for tasty, tight, tidbits of advice and code that you can put to immediate use in your world of programming. |
|
Always Bulk Collect |
|
StevenFeuersteinTW
|
Monday, June 23, 2008 7:34 AM
|
|
|
|
You learn something new every day, right? Well, I certainly do (more or less). Even about PL/SQL, about which I am sure many people think I already know everything. Far from it.
In fact, I learned just last week from the PL/SQL Product Manager, Bryn Llewellyn, that his recommendation regarding cursor FOR loops and bulk collect is different fro ...
|
 |
|
Comments (4)
|
Read More...
|
|
|
How to Run an OS Command from PL/SQL |
|
StevenFeuersteinTW
|
Wednesday, June 04, 2008 7:11 AM
|
|
|
|
Oracle doesn't make it terribly easy to run operating system commands from within a PL/SQL block. I suppose that's understandable, given that PL/SQL is an embedded database-oriented language. Still, developers do ask me on a regular basis about how they can do this.
As I understand it, there are basically three ways to do this:
- Invoke a Java method from wit ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Testing and refreshing data from production |
|
StevenFeuersteinTW
|
Thursday, April 17, 2008 9:21 AM
|
|
|
|
As many of my readers likely know by now, I have been working for the past several years on the Quest Code Tester development effort.
Code Tester is the most powerful PL/SQL test automation tool available. You describe the expected behavior of your programs and Code Tester generates your test code, which can then be run from the UI or via a script. With Code Teste ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Auto-formatting of templates for Toad |
|
StevenFeuersteinTW
|
Thursday, April 10, 2008 9:14 AM
|
|
|
|
A few months ago, I posted on this blog an explanation of how to use Toad's Code Templates to standardize development and improve productivity. I included an XML document that contains over 20 templates that I thought you might find useful. I also asked my readers to produce XML transformations so that the XML document could be "output" in the format that Toad recognizes (and SQL Navigator as ...
|
|
|
|
Comments (2)
|
Read More...
|
|
|
Weird PL/SQL |
|
StevenFeuersteinTW
|
Monday, March 17, 2008 12:57 PM
|
|
|
|
Collaborate08, annual conference of the International Oracle User Group, and several other national and international user groups, will be held in Denver this year, from April 13th to the 16th. I am going to present three papers, including (for the first time) Weird PL/SQL. I thought you might enjoy reading about some of the weirdnesses of PL/S ...
|
|
|
|
Comments (0)
|
Read More...
|
|
|
Just how popular is PL/SQL? |
|
StevenFeuersteinTW
|
Monday, February 04, 2008 11:56 AM
|
|
|
|
Just how popular is PL/SQL?
And how many PL/SQL developers are there "out there"?
These are surprisingly hard questions to answer. Officially and even unofficially, Oracle Corporation's point people on PL/S ...
|
|
|
|
Comments (1)
|
Read More...
|
|
|
|
Single quotes and CLOBs in 10.2.0.3 |
|
StevenFeuersteinTW
|
Wednesday, December 19, 2007 5:41 PM
|
|
|
|
I usually write about best practice principles and general issues.
Today I thought I would share a bit of my pain with you on a very specific topic: single quotes and CLOBs, and specifically on O ...
|
|
|
|
Comments (3)
|
Read More...
|
|
|
|
My Favorite Templates – in one convenient file |
|
StevenFeuersteinTW
|
Wednesday, November 28, 2007 1:24 PM
|
|
|
|
Would you like to increase productivity, improve code quality, and ensure that standards are being followed? Of course you would! And one of the best ways to do that is to rely heavily on Toad's Code Templates (similar functionality exists in SQL Navigator as well).
|
|
|
|
Comments (1)
|
Read More...
|
|
|
|
|
|
|
|
|
|
|