Oracle Magazine PL/SQL Columns


Steven Feuerstein Headshot Steven Feuerstein (steven.feuerstein@oracle.com) is an architect for Oracle, specializing in PL/SQL. His books, including Oracle PL/SQL Programming, and over 1,000 PL/SQL quizzes at the PL/SQL Challenge (plsqlchallenge.com) provide in-depth resources for PL/SQL developers.


Pub Date

Title

Description

November/December 2014 Planning for Trouble You always write your best code, but you should be prepared for imperfection.
 
September/October 2014 Persistence Doesn’t Always Pay Sometimes you don’t want a database table and SQL. Sometimes you just want to collect your thoughts.
 
July/August 2014 The Joy of Low- Hanging Fruit Are you using BULK COLLECT and FORALL for bulk processing yet?
 
May/June 2014 Writing SQL in Oracle Application Express Minimize the code you write, be careful where you put it, and relocate it to packages as much as possible.
 
March/April 2014 Writing PL/SQL in Oracle Application Express Minimize the code you write, be careful where you put it, and relocate it to packages as much as possible.
 
January/February 2014 Sophisticated Call Stack Analysis UTL_CALL_STACK package in Oracle Database 12c gives developers better answers.
 
November/December 2013 SQL in PL/SQL Enhancements Oracle Database 12c enhances writing and executing SQL in PL/SQL
 
September/October 2013 PL/SQL Enhancements Oracle Database 12c enhances the PL/SQL function result cache, improves PL/SQL execution in SQL, adds a whitelist, and fine-tunes privileges.
 
March/April 2013 Working with Cursors Part 12 in a series of articles on understanding and using PL/SQL
 
January/February 2013 Wrap Your Code in a Neat Package Part 11 in a series of articles on understanding and using PL/SQL
 
November/December 2012 The Data Dictionary: Make Views Work for You Part 10 in a series of articles on understanding and using PL/SQL
 
September/October 2012 Bulk Processing with BULK COLLECT and FORALL Part 9 in a series of articles on understanding and using PL/SQL
 
July/August 2012 Working with Collections Part 8 in a series on understanding and using PL/SQL
 
May/June 2012 Working with Records Part 7 in a series of articles on understanding and using PL/SQL
 
March/April 2012 Error Management Part 6 in a series of articles on understanding and using PL/SQL
 
January/February 2012 Working with Dates in PL/SQL Part 5 in a series of articles on understanding and using PL/SQL
 
November/December 2011 Working with Numbers in PL/SQL Part 4 in a series of articles on understanding and using PL/SQL.
 
September/October 2011 Working with Strings Part 3 in a series of articles on understanding and using PL/SQL.
 
July/August 2011 Controlling the Flow of Execution Part 2 in a series of articles on understanding and using PL/SQL.
 
March/April 2011 Building with Blocks Part 1 in a series of articles on understanding and using PL/SQL.
 
September/October 2010 Zoom In on Your Code Use PL/Scope to analyze your PL/SQL.
 
May/June 2010 On Working in Parallel Finish faster with DBMS_PARALLEL_EXECUTE.
 
January/February 2010 On Privacy and Function Use Oracle Virtual Private Database and Function Result Cache—securely.
 
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 10g.
 
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.