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).

When Packages Need to Lose Weight

Slim your PL/SQL with some reorganization and a new Oracle Database 12c feature. By Steven Feuerstein January/February 2015 Over several months, the development...

Planning for Trouble

You always write your best code, but you should be prepared for imperfection. By Steven Feuerstein November/December 2014 The folks at extremememe.info have been...

Persistence Doesn’t Always Pay

Sometimes you don’t want a database table and SQL. Sometimes you just need to collect your thoughts. By Steven Feuerstein September/October 2014 In my last...

The Joy of Low-Hanging Fruit

Are you using BULK COLLECT and FORALL for bulk processing yet? By Steven Feuerstein July/August 2014 The following is based on true events. The names have...

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. By Steven Feuerstein May/June 2014 In the last issue of...

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. By Steven Feuerstein March/April 2014 Oracle...

Sophisticated Call Stack Analysis

UTL_CALL_STACK package in Oracle Database 12c gives developers better answers. By Steven Feuerstein January/February 2014 This third and last article on new...

SQL in 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. By Steven...

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. By Steven...