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, Part 2

Use the SODA API for PL/SQL to read and write to SODA documents in Oracle Database. By Steven Feuerstein July/August 2019 In my first article on SODA (Simple...

Easy Initializing for Records and Arrays

Use the new qualified expressions to create functions when and where you need them. By Steven Feuerstein May/June 2019 As anyone who has followed me over the...

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