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 Is a Function Like a Table? When It’s a Table Function!

Combine the power of SQL with the procedural control of PL/SQL. By Steven Feuerstein July/August 2018 What does a PL/SQL function do? A function returns a value....

Working with JSON Arrays in PL/SQL

Use the PL/SQL JSON_ARRAY_T object type to construct and manipulate in-memory JSON arrays. By Steven Feuerstein May/June 2018 As explored in my last Oracle...

JSON and PL/SQL: A Match Made in Database

PL/SQL object types for JSON construct and manipulate in-memory JSON data. By Steven Feuerstein March/April 2018 Oracle Database 12c Release 1 ushered in a new age...

Just Say No, Unless You Can’t

Dynamic SQL is powerful, flexible, and fraught with risk. Use it only when absolutely necessary. By Steven Feuerstein January/February 2018 Whether you run Oracle...

Just Say No, Unless You Can’t

Listing 1: Package body for exec_any_sql PACKAGE BODY exec_any_sql IS PROCEDURE delete_from (schema_in IN VARCHAR2 DEFAULT USER, ...

Using Dynamic SQL for Multirow Queries

Explore three dynamic SQL solutions to understand which is best for your program requirements. By Steven Feuerstein November/December 2017 Most of the SQL...

Fine-Tune Privilege Management

Improve PL/SQL security in Oracle Database 12c. By Steven Feuerstein July/August 2017 Oracle Database 12c offers several enhancements to improve security in your...

Get Up to Speed with DBMS_SQL

Explore the latest DBMS_SQL features in Oracle Database 12c Release 2. By Steven Feuerstein March/April 2017 DBMS_SQL offers a broad and deep API for executing...

Powerful Impact Analysis

Easily identify program units affected by database object changes with PL/Scope in Oracle Database 12c Release 2. By Steven Feuerstein January/February 2017 PL/Sco...