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

Streaming Table Functions

Transform your data on the way to your data warehouse. By Steven Feuerstein September/October 2018 A table function is a function you can use like a table in the...

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