Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

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

Is_number

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

Export-import scripts

A collection of Korn shell scripts to export and import tables or schemas, with or without compression. February 2002

Pl/sql timer

A simple package to output the elapsed time between two points. Supports versions from 8i onwards. July 2005