Adrian Billington

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

Returning with

Fri, 2009-05-22 03:00
A workaround to the unsupported INSERT..SELECT..RETURNING construct. August 2005 (updated May 2009)

Dynamic logging with global application context

Wed, 2009-04-22 03:00
Controlling logging output across sessions using global application context. September 2007 (updated April 2009)

Virtual columns in 11g

Wed, 2008-10-22 03:00
Store expressions as virtual columns in Oracle 11g. October 2008

Binding in-lists in 10g

Thu, 2008-09-18 14:16
Alternative IN-list binding in 10g using the new MEMBER OF collection condition. June 2004 (updated September 2008)

Partition-wise dependencies in 10g release 2

Fri, 2008-08-22 03:00
Modify partitions without invalidating dependant objects. October 2007 (updated August 2008)

The collect function in 10g

Tue, 2008-07-22 03:00
Using the new 10g COLLECT group function, including string aggregation. June 2004 (updated July 2008)

Pl/sql enhancements in oracle 11g

Thu, 2008-05-22 03:00
Various minor language and operability enhancements for PL/SQL in 11g. May 2008

Regular expression enhancements in 11g

Thu, 2008-05-22 03:00
Oracle 11g adds a new REGEXP_COUNT function and extends some of the existing functions. May 2008

Pl/sql counter

Thu, 2008-05-22 03:00
A simple package to start and maintain a session-based counter. Useful for debugging and instrumentation. May 2008

Pipelined function issues

Thu, 2008-05-22 03:00
A few "gotchas" to be aware of when using pipelined functions. September 2007 (updated May 2008)

Pivot and unpivot queries in 11g

Tue, 2008-04-22 03:00
Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008

Pl/sql optimisation in 10g

Sat, 2008-03-22 03:00
Oracle 10g's compiler optimisation for faster PL/SQL, with a new section on optimisation bugs. November 2004 (updated March 2008)

Tuning pl/sql file i/o

Mon, 2008-02-18 13:12
Various techniques for unloading data to flat-file faster. February 2008

Query result cache in oracle 11g

Sat, 2007-12-22 02:00
Oracle adds a new cache for storing the results of queries. December 2007

Pls-00436 removed in oracle 11g

Thu, 2007-11-22 02:00
Oracle relaxes the long-standing FORALL implementation restriction in 11g. November 2007

Subprogram inlining in 11g

Thu, 2007-11-22 02:00
Oracle extends the scope of its PL/SQL compiler optimisation. November 2007

Sql plan enhancements in 10g

Thu, 2007-11-22 02:00
New plan features in 10g make SQL performance investigations much more simple. December 2004 (updated November 2007)

Emulating string-to-table functionality using sql

Wed, 2007-08-22 03:00
Turning delimited strings into multiple records without PL/SQL. July 2005 (updated August 2007)

Flexible pipelined functions

Wed, 2007-08-22 03:00
Combining pipelined functions, polymorphism and multi-table inserts. August 2007

Method 4 dynamic sql in pl/sql

Wed, 2007-08-22 03:00
Using ANYDATASET and pipelined functions to achieve native Method 4 Dynamic SQL. August 2007