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 Invokers and Outs

Best practices for invoker rights and functions By Steven Feuerstein July/August 2007 I have made lots of use of the AUTHID CURRENT_USER (invoker rights) clause...

On the Old, the New, and ORA-22160

Best practices for managing old and new information and preventing FORALL errors By Steven Feuerstein May/June 2007 I want to audit updates to a table, including...

The Right Place for PL/SQL

Best practices for PL/SQL location, location, location By Steven Feuerstein January/February 2007 I write packages and procedures in both Oracle Database and...

On Object Types in Collections

Best practices for retrieving objects and object attributes from objects By Steven Feuerstein November/December 2006 I have declared an object type, varray, that...

On Generics and Traces

Best Practices for String Procedures and Tracing By Steven Feuerstein September/October 2006 What is the best way to write generic procedures to work on strings...

On Conditional Compilation

Apply best practices to PL/SQL conditional compilation. By Steven Feuerstein July/August 2006 What is PL/SQL conditional compilation, how does it work, and how can...

On Confusion and Recompilation

  Apply best practices to program naming, recompiling invalid programs, and collecting. By Steven Feuerstein May/June 2006   I have a package named pck_events_1 that...

On Variables, Moving, and Meaning

  Apply best practices to cursor variables, bidirectional cursor access, and error messages. By Steven Feuerstein March/April 2006   I have a stored procedure that...

Answering PL/SQL

  Apply best practices to defining arrays and stripping strings. By Steven Feuerstein January/February 2006   PL/SQL expert Steven Feuerstein answers your PL/SQL...