Returning with insert..select

Uncategorized
| May 6, 2009
A workaround to the unsupported INSERT..SELECT..RETURNING construct. August 2005 (updated May 2009)

Dynamic logging with global application context

Uncategorized
| Apr 30, 2009
Controlling logging output across sessions using global application context. September 2007 (updated April 2009)

Virtual columns in 11g

Uncategorized
| Oct 10, 2008
Store expressions as virtual columns in Oracle 11g. October 2008

Binding in-lists in 10g

Uncategorized
| Sep 11, 2008
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

Uncategorized
| Aug 20, 2008
Modify partitions without invalidating dependant objects. October 2007 (updated August 2008)

The collect function in 10g

Uncategorized
| Jul 11, 2008
Using the new 10g COLLECT group function, including string aggregation. June 2004 (updated July 2008)

Regular expression enhancements in 11g

Uncategorized
| May 20, 2008
Oracle 11g adds a new REGEXP_COUNT function and extends some of the existing functions. May 2008

Pl/sql counter

Uncategorized
| May 8, 2008
A simple package to start and maintain a session-based counter. Useful for debugging and instrumentation. May 2008

Pipelined function issues

Uncategorized
| May 6, 2008
A few "gotchas" to be aware of when using pipelined functions. September 2007 (updated May 2008)

Pl/sql enhancements in oracle 11g

Uncategorized
| May 4, 2008
Various minor language and operability enhancements for PL/SQL in 11g. May 2008

Pivot and unpivot queries in 11g

Uncategorized
| Apr 4, 2008
Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008

Pl/sql optimisation in 10g

Uncategorized
| Mar 5, 2008
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

Uncategorized
| Feb 6, 2008
Various techniques for unloading data to flat-file faster. February 2008

Query result cache in oracle 11g

Uncategorized
| Dec 4, 2007
Oracle adds a new cache for storing the results of queries. December 2007

Subprogram inlining in 11g

Uncategorized
| Nov 28, 2007
Oracle extends the scope of its PL/SQL compiler optimisation. November 2007

Pls-00436 removed in oracle 11g

Uncategorized
| Nov 28, 2007
Oracle relaxes the long-standing FORALL implementation restriction in 11g. November 2007

Sql plan enhancements in 10g

Uncategorized
| Nov 5, 2007
New plan features in 10g make SQL performance investigations much more simple. December 2004 (updated November 2007)

Emulating string-to-table functionality using sql

Uncategorized
| Aug 11, 2007
Turning delimited strings into multiple records without PL/SQL. July 2005 (updated August 2007)

Method 4 dynamic sql in pl/sql

Uncategorized
| Aug 8, 2007
Using ANYDATASET and pipelined functions to achieve native Method 4 Dynamic SQL. August 2007

Flexible pipelined functions

Uncategorized
| Aug 7, 2007
Combining pipelined functions, polymorphism and multi-table inserts. August 2007