Adrian Billington
Articles and utilities available at oracle-developer.net
Updated: 5 days 4 min ago
Returning with insert..select
A workaround to the unsupported INSERT..SELECT..RETURNING construct. August 2005 (updated May 2009)
Dynamic logging with global application context
Controlling logging output across sessions using global application context. September 2007 (updated April 2009)
Virtual columns in 11g
Store expressions as virtual columns in Oracle 11g. October 2008
Binding in-lists in 10g
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
Modify partitions without invalidating dependant objects. October 2007 (updated August 2008)
The collect function in 10g
Using the new 10g COLLECT group function, including string aggregation. June 2004 (updated July 2008)
Pl/sql enhancements in oracle 11g
Various minor language and operability enhancements for PL/SQL in 11g. May 2008
Regular expression enhancements in 11g
Oracle 11g adds a new REGEXP_COUNT function and extends some of the existing functions. May 2008
Pl/sql counter
A simple package to start and maintain a session-based counter. Useful for debugging and instrumentation. May 2008
Pipelined function issues
A few "gotchas" to be aware of when using pipelined functions. September 2007 (updated May 2008)
Pivot and unpivot queries in 11g
Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008
Pl/sql optimisation in 10g
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
Various techniques for unloading data to flat-file faster. February 2008
Query result cache in oracle 11g
Oracle adds a new cache for storing the results of queries. December 2007
Pls-00436 removed in oracle 11g
Oracle relaxes the long-standing FORALL implementation restriction in 11g. November 2007
Subprogram inlining in 11g
Oracle extends the scope of its PL/SQL compiler optimisation. November 2007
Sql plan enhancements in 10g
New plan features in 10g make SQL performance investigations much more simple. December 2004 (updated November 2007)
Emulating string-to-table functionality using sql
Turning delimited strings into multiple records without PL/SQL. July 2005 (updated August 2007)
Flexible pipelined functions
Combining pipelined functions, polymorphism and multi-table inserts. August 2007
Method 4 dynamic sql in pl/sql
Using ANYDATASET and pipelined functions to achieve native Method 4 Dynamic SQL. August 2007