Search

Top 60 Oracle Blogs

Recent comments

January 2010

Overcoming the limitations of set row

Techniques to avoid superfluous updates with SET ROW. June 2007

Flexible pipelined functions

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

tweet …

For people that have asked - I'm not blogging simply because I'm feverishly working on a tool of mine that I'm very fond of :)

Guess what it does from the following next two screenshots ...

tool_lines2

tool_prof1

Tuning pl/sql file i/o

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

Pipelined function issues

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

Returning with insert..select

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

Pl/sql functions and cbo costing

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

Introduction to 8i bulk pl/sql processing

Oracle 8i now supports native array processing in PL/SQL. December 2001

Case expressions and statements in oracle 9i

Extended CASE expressions and the new CASE statement in 9i. May 2002

Multilevel collections in oracle 9i

Oracle 9i supports collections of collections of collections... October 2002