Pub Date |
Title |
Description |
| September/October 2009 |
On Looping, First, and Last |
Choose the best approach to prevent a VALUE_ERROR exception. |
| July/August 2009 |
First Things First |
Ask the right questions before starting construction of your new PL/SQL-based application. |
| May/June 2009 |
The Magic Kingdom |
Choose the best way to manage literal values. |
| March/April 2009 |
On Avoiding Termination |
Continue PL/SQL execution beyond exceptions. |
| January/February 2009 |
On Emulating FINALLY |
Code PL/SQL to function like the Java FINALLY section. |
| November/December 2008 |
On Cursor FOR Loops |
It’s important to know when not to use cursor FOR loops. |
| September/October 2008 |
On Signatures and Changing WHERE |
Best practices for changing headers and handling different WHERE clauses. |
| July/August 2008 |
On Exceptions and Rules |
Best practices for where, when, and how to handle exceptions |
| May/June 2008 |
On the PGA and Indexing
Collections |
Best practices for knowing your PGA impact and indexing collections |
| March/April 2008 |
On BULK COLLECT |
Best practices for knowing your LIMIT and kicking %NOTFOUND. |
| November/December 2007 |
On Continuing and Executing |
Best practices for PL/SQL in Oracle Database 11g and multilevel, string-indexed collections. |
| September/October 2007 |
On the PL/SQL Function Result Cache |
Best practices—and preparation—for PL/SQL in Oracle Database 11g. |
| July/August 2007 |
On Invokers and Outs |
Best practices for invoker rights and functions. |
| May/June 2007 |
On the Old, the New, and ORA-22160 |
Best practices for managing old and new information and preventing FORALL errors. |
| January/February 2007 |
The Right Place for PL/SQL |
Best practices for PL/SQL location, location, location |
| November/December 2006 |
On Object Types in Collections |
Best practices for retrieving objects and object attributes from objects
|
| September/October 2006 |
On Generics and Traces |
Best practices for string procedures and tracing
|
| July/August 2006 |
On Conditional Compilation |
Apply best practices to PL/SQL conditional compilation. |
| May/June 2006 |
On Confusion and Recompilation |
Apply best practices to program naming, recompiling invalid programs, and collecting.
|
| March/April 2006 |
On Variables, Moving, and Meaning |
Apply best practices to cursor variables, bidirectional cursor access, and error messages.
|
| January/February 2006 |
Answering PL/SQL |
Apply best practices to defining arrays and stripping strings.
|
| May/June 2005 |
Picking Your Packages |
Know when—and when not—to package your
PL/SQL.
|
| March/April 2005 |
Tracing Lines |
Find and report your errors—by line number—in Oracle Database 10g. |
| January/February 2005 |
Refactoring for PL/SQL Developers |
Go beyond identifying best PL/SQL practices to create better code. |
| November/December 2004 |
Better to Best NDS |
Best-practice tips for using Native Dynamic SQL in Oracle Database 10g. |
| September/October 2004 |
Controlling Mythological Code |
Explode and decode the myths in your code. |
| July/August 2004 |
The Beauty Is in the Details |
Pay attention to the details in conditions, loops, and declarations, and create better code. |
| May/June 2004 |
Self-Managing PL/SQL |
Follow self-managing databases with self-managing PL/SQL . |
| March/April 2004 |
Cleaning Up PL/SQL Practices |
Prioritize and apply PL/SQL best practices to polish applications both new and old |
| January/February 2004 |
Oracle 10g Adds More to FORALL |
FORALL begins, BULK COLLECT builds, and VALUES OF excels. |
| November/December 2003 |
Disciplined PL/SQL |
Four simple guidelines for improving the quantity and quality of PL/SQL code you write |
| September/October 2003 |
Taking Up Collections |
Part 1 in a series that looks at enrichments to PL/SQL in Oracle Database 10 g. |
| July/August 2003 |
Handling Exceptional Behavior, Part II |
Handle PL/SQL exceptions with best practices. |
| May/June 2003 |
Managing Exceptional Behavior, Part 1 |
Handle PL/SQL exceptions with best practices. |
| January/February 2003 |
Strings Attached |
Now you can index by strings and improve performance. |
Bookmark
