Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

January 2007

Measuring cpu time in 10g

Submitted by Adrian Billington on Fri, 2007-01-26 18:32

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

Aggregating data with the returning clause

Submitted by Adrian Billington on Fri, 2007-01-26 18:30

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

Replacef

Submitted by Adrian Billington on Mon, 2007-01-22 08:00

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

Put_line

Submitted by Adrian Billington on Tue, 2007-01-16 07:17

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

Submitted by Adrian Billington on Mon, 2007-01-15 22:15

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

Replacef

Submitted by Adrian Billington on Thu, 2007-01-11 21:59

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

Is_number

Submitted by Adrian Billington on Thu, 2007-01-11 18:01

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

Showplan utility

Submitted by Adrian Billington on Thu, 2007-01-11 17:58

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