Anydata and anytype in 9i

Uncategorized
| Jul 11, 2007
An introduction to generic types in Oracle 9i. October 2002 (updated July 2007)

Encapsulating bulk pl/sql exceptions

Uncategorized
| Jul 11, 2007
Using object features to encapsulate FORALL .. SAVE EXCEPTIONS error-handling. July 2007

Overcoming the limitations of set row

Uncategorized
| Jun 7, 2007
Techniques to avoid superfluous updates with SET ROW. June 2007

External tables in oracle 9i

Uncategorized
| Jun 6, 2007
Select directly from flat-files as though they are tables. August 2002 (updated June 2007)

Subquery factoring in oracle 9i

Uncategorized
| Jun 6, 2007
A new way of expressing subqueries in 9i. December 2005 (updated June 2007)

Ansi joins in oracle 9i

Uncategorized
| Jun 6, 2007
Oracle adds ANSI-compliant joins to SQL in 9i. January 2003 (updated June 2007)

Type enhancements in oracle 9i

Uncategorized
| Jun 6, 2007
Constructor functions, type evolution and substitution in 9i. December 2005 (updated June 2007)

Pipelined functions in oracle 9i

Uncategorized
| May 17, 2007
Functions can now stream data as virtual tables. May 2002 (updated May 2007)

Replacef

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

Showplan utility

Uncategorized
| Oct 11, 2006
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

Uncategorized
| Oct 7, 2006
Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006

Loading xml files with xml db

Uncategorized
| Mar 4, 2006
A tutorial on loading XML files into relational tables. March 2006

Dml error logging performance in 10g release 2

Uncategorized
| Aug 15, 2005
Performance characteristics of DML error logging. August 2005

Autotrace enhancement in 10g release 2

Uncategorized
| Aug 11, 2005
Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005

Dml error logging in oracle 10g release 2

Uncategorized
| Aug 10, 2005
A new error logging mechanism for bulk DML statements. August 2005

Flashback version query in oracle 10g

Uncategorized
| Aug 7, 2005
We can now view the evolution of our data with flashback version query. August 2005

Enhancements to dbms_output in 10g release 2

Uncategorized
| Aug 1, 2005
Oracle finally "fixes" DBMS_OUTPUT. August 2005

Flashback restore points in oracle 10g release 2

Uncategorized
| Aug 1, 2005
Restore points enable us to capture a point in time for flashback operations. August 2005

Array-based advanced queuing in 10g

Uncategorized
| Jul 16, 2005
Oracle 10g enables us to enqueue and dequeue in bulk. July 2005

Introduction to advanced queuing

Uncategorized
| Jul 8, 2005
A high-level tutorial on Oracle's Advanced Queuing. July 2005