January 2007

Measuring cpu time in 10g

An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004

Aggregating data with the returning clause

In 10g, data returned by the RETURNING clause can be aggregated. June 2004

Replacef

A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007

Put_line

A simple wrapper to DBMS_OUTPUT.PUT_LINE to workaround the 255 byte limit (not needed from 10.2 onwards). April 2002

Call stack parser

A small package of functions for parsing the PL/SQL call stack. Includes an implementation of "WHOAMI" and "CALLER". September 2003

Replacef

A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007

Is_number

Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006

Showplan utility

Simple SQL*Plus utilities to output the real execution plans used by running or cached SQL statements. Available for 9i Release 2 and 10g. October 2006