Oracle Magazine PL/SQL Columns
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.

E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy