Replacef
Posted January 22, 2007A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007
Put_line
Posted January 16, 2007A simple wrapper to DBMS_OUTPUT.PUT_LINE to workaround the 255 byte limit (not needed from 10.2 onwards). April 2002
Call stack parser
Posted January 15, 2007A small package of functions for parsing the PL/SQL call stack. Includes an implementation of "WHOAMI" and "CALLER". September 2003
Replacef
Posted January 11, 2007A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007
Is_number
Posted January 11, 2007Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006
Showplan utility
Posted January 11, 2007Simple 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
Posted October 31, 2006Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006
Export-import scripts
Posted October 30, 2006A collection of Korn shell scripts to export and import tables or schemas, with or without compression. February 2002
Pl/sql timer
Posted July 22, 2005A simple package to output the elapsed time between two points. Supports versions from 8i onwards. July 2005
Domains, Domains, My Kingdom for a Domain!
Posted November 1, 2004An 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.