Search

OakieTags

more tags

Who's online

There are currently 0 users and 29 guests online.

Recent comments

Affiliations

Home

Miscellaneous Articles

Working with long columns

Submitted by abb on Thu, 2010-07-29 22:32

Various techniques for querying and manipulating long columns. July 2010

Improving performance with pipelined table functions

Submitted by abb on Thu, 2010-01-21 22:06

Using pipelined functions as a performance tuning tool. January 2010

Method 4 dynamic sql in pl/sql

Submitted by abb on Sat, 2010-01-09 00:13

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

Overcoming the limitations of set row

Submitted by abb on Thu, 2010-01-07 07:46

Techniques to avoid superfluous updates with SET ROW. June 2007

Flexible pipelined functions

Submitted by abb on Thu, 2010-01-07 07:36

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

Tuning pl/sql file i/o

Submitted by abb on Wed, 2010-01-06 18:34

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

Pipelined function issues

Submitted by abb on Wed, 2010-01-06 18:28

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

Returning with insert..select

Submitted by abb on Wed, 2010-01-06 18:20

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

Pl/sql functions and cbo costing

Submitted by abb on Wed, 2010-01-06 18:14

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

Emulating string-to-table functionality using sql

Submitted by abb on Fri, 2009-12-11 19:48

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