Subscribe

Author Profile

Steven Feuerstein
Developer Advocate for PL/SQL

Steven Feuerstein is Oracle Corporation's Developer Advocate for PL/SQL, and an expert on the Oracle PL/SQL language, having written ten books on PL/SQL, including Oracle PL/SQL Programming and Oracle PL/SQL Best Practices (all published by O'Reilly Media). Steven has been developing software since 1980, spent five years with Oracle back in the "old days" (1987-1992), and was PL/SQL Evangelist for Quest Software (and then Dell) from January 2001 to February 2014 - at which point he returned joyfully to Oracle Corporation. He was one of the original Oracle ACE Directors and writes regularly for Oracle Magazine, which named him the PL/SQL Developer of the Year in both 2002 and 2006. He is also the first recipient of ODTUG's Lifetime Achievement Award (2009).

On Avoiding Termination

Continue PL/SQL execution beyond exceptions. By Steven Feuerstein March/April 2009 I have been assigned the job of modifying an existing procedure that applies a...

On Emulating FINALLY

Code PL/SQL to function like the Java FINALLY section. By Steven Feuerstein January/February 2009 I just moved over from the Java world to PL/SQL. One thing...

On Cursor FOR Loops

It’s important to know when not to use cursor FOR loops. By Steven Feuerstein November/December 2008 My mentor told me that when querying data I should always use...

On Signatures and Changing WHERE

Best practices for changing headers and handling different WHERE clauses By Steven Feuerstein September/October 2008 I maintain a large application implemented in...

On Exceptions and Rules

Best practices for where, when, and how to handle exceptions By Steven Feuerstein July/August 2008 I recently learned that if an exception is raised in the...

On the PGA and Indexing Collections

Best practices for knowing your PGA impact and indexing collections By Steven Feuerstein May/June 2008 My DBA wants me to reduce the amount of PGA (program global...

On BULK COLLECT

Best practices for knowing your LIMIT and kicking %NOTFOUND By Steven Feuerstein March/April 2008 I have started using BULK COLLECT whenever I need to fetch large...

On Continuing and Indexing

Best practices for PL/SQL in Oracle Database 11g and multilevel, string-indexed collections By Steven Feuerstein November/December 2007 I have been assigned one of...

On the PL/SQL Function Result Cache

Best practices—and preparation—for PL/SQL in Oracle Database 11g By Steven Feuerstein September/October 2007 I have been reading that Oracle is launching the...