Oakies Blog Aggregator

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

Domains, Domains, My Kingdom for a Domain!

An exploration: Can Oracle's user-defined type system be put to use in
implementing domains and strict type-checking in the manner once envisioned
by database pioneers Ted Codd and Chris Date?



Read the full post at www.gennick.com/database.

Domains, Domains, My Kingdom for a Domain!

An exploration: Can Oracle's user-defined type system be put to use in
implementing domains and strict type-checking in the manner once envisioned
by database pioneers Ted Codd and Chris Date?



Read the full post at www.gennick.com/database.

Merge counter

A package to capture and report separate INSERT and UPDATE rowcounts from a MERGE statement. February 2004

Data dump utility

Procedure to dump the contents of a table or the results of a query to flat file. February 2004

Call stack parser

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