Search

OakieTags

Who's online

There are currently 0 users and 35 guests online.

Recent comments

Oakies Blog Aggregator

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

Put_line

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