Search

OakieTags

more tags

Who's online

There are currently 1 user and 28 guests online.

Online users

Recent comments

Affiliations

Home

Miscellaneous Articles

Working with long columns

Submitted by Adrian Billington on Thu, 2010-07-29 23:32

Various techniques for querying and manipulating long columns. July 2010 (updated March 2012)

Improving performance with pipelined table functions

Submitted by Adrian Billington on Thu, 2010-01-21 23:06

Using pipelined functions as a performance tuning tool. January 2010

Method 4 dynamic sql in pl/sql

Submitted by Adrian Billington on Sat, 2010-01-09 01:13

Using ANYDATASET and pipelined functions to achieve native Method 4 Dynamic SQL. August 2007

Overcoming the limitations of set row

Submitted by Adrian Billington on Thu, 2010-01-07 08:46

Techniques to avoid superfluous updates with SET ROW. June 2007

Flexible pipelined functions

Submitted by Adrian Billington on Thu, 2010-01-07 08:36

Combining pipelined functions, polymorphism and multi-table inserts. August 2007

Tuning pl/sql file i/o

Submitted by Adrian Billington on Wed, 2010-01-06 19:34

Various techniques for unloading data to flat-file faster. February 2008

Pipelined function issues

Submitted by Adrian Billington on Wed, 2010-01-06 19:28

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

Returning with insert..select

Submitted by Adrian Billington on Wed, 2010-01-06 19:20

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

Pl/sql functions and cbo costing

Submitted by Adrian Billington on Wed, 2010-01-06 19:14

Associating statistics with PL/SQL functions for greater CBO accuracy. June 2009

Emulating string-to-table functionality using sql

Submitted by Adrian Billington on Fri, 2009-12-11 20:48

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