Adrian Billington

Subscribe to Adrian Billington feed
Articles and utilities available at
Updated: 2 days 4 hours ago

Call stack parser

Mon, 2003-09-22 03:00
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

Fri, 2003-08-22 03:00
A method for getting insert and update counts from a MERGE operation. August 2003

Flashback query in oracle 9i

Fri, 2002-11-22 02:00
We can now query data from a previous point in time. November 2002

Multilevel collections in oracle 9i

Tue, 2002-10-22 03:00
Oracle 9i supports collections of collections of collections... October 2002

Multi-table inserts in oracle 9i

Tue, 2002-10-22 03:00
We can now insert into multiple tables from a single statement. October 2002

The merge statement in oracle 9i

Sun, 2002-09-22 03:00
Update or insert data from a single DML statement in 9i. September 2002

Case expressions and statements in oracle 9i

Wed, 2002-05-22 03:00
Extended CASE expressions and the new CASE statement in 9i. May 2002

Associative arrays in oracle 9i release 2

Wed, 2002-05-22 03:00
Oracle extends its PL/SQL array processing capabilities. May 2002


Mon, 2002-04-22 03:00
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

Fri, 2002-02-22 02:00
Oracle 8.1.6 introduces a wide range of powerful new "windowing" functions. February 2002

Introduction to 8i bulk pl/sql processing

Sat, 2001-12-22 02:00
Oracle 8i now supports native array processing in PL/SQL. December 2001