Pub Date |
Title |
Description |
| 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. |
| September/October 2002 |
Catching Up on Filing |
Oracle9i Release 2 UTL_FILE enhances file I/O. |
| May/June 2002 |
Programming at Multiple Levels |
Oracle9i Database lets you nest collections and create powerful data structures. |
| January/February 2002 |
Oracle9i PL/SQL Transforms and Perform |
In Oracle9i, PL/SQL performance is enhanced by native compilation and table functions, and the language becomes more efficient. |
| September/October 2001 |
Making Smart PL/SQL Scanning of XML Documents |
In the conclusion of this two-part series, a PL/SQL expert again scans XML and maps its benefits to PL/SQL. |
| July/August 2001 |
XML for the PL/SQL Developer |
Understanding the power of XML and how XML and PL/SQL can work together. |
| March/April 2001 |
Advanced Topics in Native Dynamic SQL |
Learning a few subtleties of Oracle8i's native dynamic SQL can greatly expand the range of your PL/SQL programming capabilities. |
| January/February 2001 |
A Dynamic Approach to Multirow Queries |
Use the extended OPEN FOR syntax in Oracle8i's PL/SQL to quickly create dynamically constructed SQL queries that return multirow result sets. |
Bookmark
