Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

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.

Data dump utility

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

Merge counter

A package to capture and report separate INSERT and UPDATE rowcounts from a MERGE statement. 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