Adrian Billington

Subscribe to Adrian Billington feed
Articles and utilities available at oracle-developer.net
Updated: 6 days 13 hours ago

Anydata and anytype in 9i

Sun, 2007-07-22 03:00
An introduction to generic types in Oracle 9i. October 2002 (updated July 2007)

Encapsulating bulk pl/sql exceptions

Sun, 2007-07-22 03:00
Using object features to encapsulate FORALL .. SAVE EXCEPTIONS error-handling. July 2007

External tables in oracle 9i

Fri, 2007-06-22 03:00
Select directly from flat-files as though they are tables. August 2002 (updated June 2007)

Subquery factoring in oracle 9i

Fri, 2007-06-22 03:00
A new way of expressing subqueries in 9i. December 2005 (updated June 2007)

Ansi joins in oracle 9i

Fri, 2007-06-22 03:00
Oracle adds ANSI-compliant joins to SQL in 9i. January 2003 (updated June 2007)

Type enhancements in oracle 9i

Fri, 2007-06-22 03:00
Constructor functions, type evolution and substitution in 9i. December 2005 (updated June 2007)

Overcoming the limitations of set row

Fri, 2007-06-22 03:00
Techniques to avoid superfluous updates with SET ROW. June 2007

Pipelined functions in oracle 9i

Tue, 2007-05-22 03:00
Functions can now stream data as virtual tables. May 2002 (updated May 2007)

Replacef

Mon, 2007-01-22 02:00
A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007

Is_number

Tue, 2006-10-31 04:16
Two common, simple and effective IS_NUMBER functions for SQL and PL/SQL. October 2006

Loading xml files with xml db

Wed, 2006-03-22 02:00
A tutorial on loading XML files into relational tables. March 2006

Autotrace enhancement in 10g release 2

Mon, 2005-08-22 03:00
Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005

Flashback restore points in oracle 10g release 2

Mon, 2005-08-22 03:00
Restore points enable us to capture a point in time for flashback operations. August 2005

Flashback version query in oracle 10g

Mon, 2005-08-22 03:00
We can now view the evolution of our data with flashback version query. August 2005

Enhancements to dbms_output in 10g release 2

Mon, 2005-08-22 03:00
Oracle finally "fixes" DBMS_OUTPUT. August 2005

Dml error logging in oracle 10g release 2

Mon, 2005-08-22 03:00
A new error logging mechanism for bulk DML statements. August 2005

Dml error logging performance in 10g release 2

Mon, 2005-08-22 03:00
Performance characteristics of DML error logging. August 2005

Array-based advanced queuing in 10g

Fri, 2005-07-22 03:00
Oracle 10g enables us to enqueue and dequeue in bulk. July 2005

Pl/sql timer

Fri, 2005-07-22 03:00
A simple package to output the elapsed time between two points. Supports versions from 8i onwards. July 2005

Introduction to advanced queuing

Fri, 2005-07-22 03:00
A high-level tutorial on Oracle's Advanced Queuing. July 2005

Pages