Adrian Billington
Call stack parser
A small package of functions for parsing the PL/SQL call stack. Includes an implementation of "WHOAMI" and "CALLER". September 2003
Decomposing sql%rowcount for merge
A method for getting insert and update counts from a MERGE operation. August 2003
Flashback query in oracle 9i
We can now query data from a previous point in time. November 2002
Multilevel collections in oracle 9i
Oracle 9i supports collections of collections of collections... October 2002
Multi-table inserts in oracle 9i
We can now insert into multiple tables from a single statement. October 2002
The merge statement in oracle 9i
Update or insert data from a single DML statement in 9i. September 2002
Case expressions and statements in oracle 9i
Extended CASE expressions and the new CASE statement in 9i. May 2002
Associative arrays in oracle 9i release 2
Oracle extends its PL/SQL array processing capabilities. May 2002
Put_line
A simple wrapper to DBMS_OUTPUT.PUT_LINE to workaround the 255 byte limit (not needed from 10.2 onwards). April 2002
Introduction to 8i analytic functions
Oracle 8.1.6 introduces a wide range of powerful new "windowing" functions. February 2002
Introduction to 8i bulk pl/sql processing
Oracle 8i now supports native array processing in PL/SQL. December 2001