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

SODA and PL/SQL

Use the SODA API for PL/SQL to work with JSON— and without SQL—in Oracle Database. By Steven Feuerstein March/April 2019 SQL—Structured Query Language—is the...

Pipelined Table Functions

Pass data back to the calling query before the function is completed. By Steven Feuerstein November/December 2018 In my two previous articles “When Is a Function...

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