Setting cardinality for pipelined and table functions

Various methods for setting accurate cardinality statistics for table/pipelined functions. June 2009

Returning with

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

Dynamic logging with global application context

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

Virtual columns in 11g

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

Binding in-lists in 10g

| 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

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

The collect function in 10g

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

Regular expression enhancements in 11g

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

Pl/sql counter

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

Pipelined function issues

| 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

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

Pivot and unpivot queries in 11g

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

Pl/sql optimisation in 10g

| 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

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

Query result cache in oracle 11g

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

Subprogram inlining in 11g

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

Pls-00436 removed in oracle 11g

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

Sql plan enhancements in 10g

| 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

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

Method 4 dynamic sql in pl/sql

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