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

Working with Strings

Part 3 in a series of articles on understanding and using PL/SQL By Steven Feuerstein September/October 2011 Every application needs data. That seems rather...

Controlling the Flow of Execution

Part 2 in a series of articles on understanding and using PL/SQL By Steven Feuerstein July/August 2011 To help newcomers to PL/SQL make the most of this...

Building with Blocks

Part 1 in a series of articles on understanding and using PL/SQL By Steven Feuerstein March/April 2011 Oracle PL/SQL celebrates its 22nd birthday in 2011. I know...

Zoom In on Your Code

Use PL/Scope to analyze your PL/SQL. By Steven Feuerstein September/October 2010 Since the first release of PL/SQL, Oracle has provided a set of data dictionary...

On Working in Parallel

  Finish faster with DBMS_PARALLEL_EXECUTE. By Steven Feuerstein May/June 2010   I have to perform DML [data manipulation language] operations on millions of rows...

On Privacy and Function

Use Oracle Virtual Private Database and Function Result Cache—securely. By Steven Feuerstein January/February 2010 We just upgraded to Oracle Database 11g, and I...

On Looping, First, and Last

Choose the best approach to prevent a VALUE_ERROR exception. By Steven Feuerstein September/October 2009 If I try to use a FOR loop to iterate from FIRST to LAST...

First Things First

Ask the right questions before starting construction of your new PL/SQL-based application. By Steven Feuerstein July/August 2009 We are about to start construction...

The Magic Kingdom

Choose the best way to manage literal values. By Steven Feuerstein May/June 2009 What is the best way to avoid hard-coding literal “magic values” in my...