Adrian Billington

Subscribe to Adrian Billington feed
Articles and utilities available at oracle-developer.net
Updated: 1 week 1 day ago

Unloading data using external tables in 10g

Sun, 2005-05-22 03:00
External tables can write as well as read in 10g. May 2005

Sql tuning advisor in 10g

Mon, 2004-11-22 02:00
Oracle now offers SQL tuning recommendations. November 2004

Dual optimisation in 10g

Mon, 2004-11-22 02:00
The dual table gets a performance makeover. November 2004

Row-generation without i/o

Mon, 2004-11-22 02:00
Methods for generating dummy data without incurring I/O costs. November 2004

Exception enhancements in 10g

Tue, 2004-06-22 03:00
A few small enhancements to exception handling/error messages. June 2004

Aggregating data with the returning clause

Tue, 2004-06-22 03:00
In 10g, data returned by the RETURNING clause can be aggregated. June 2004

Forall enhancements in 10g

Tue, 2004-06-22 03:00
An overview of enhancements to FORALL bulk-binding. June 2004

Native dynamic sql optimisation in 10g

Tue, 2004-06-22 03:00
Native dynamic SQL gets an optimisation to match DBMS_SQL for efficiency. June 2004

Merge enhancements in 10g

Tue, 2004-06-22 03:00
Enhancements to the MERGE statement in 10g provide much greater flexibility. June 2004

Flashback table in 10g

Tue, 2004-06-22 03:00
Oracle extends flashback technology to restore dropped tables. June 2004

Tracking exceptions in oracle 10g

Tue, 2004-06-22 03:00
Exceptions can now be traced back to their source in 10g. June 2004

Regular expressions in 10g

Tue, 2004-06-22 03:00
Oracle finally provides support for regular expressions. June 2004

Collection extensions in 10g

Tue, 2004-06-22 03:00
A brief overview of the new collection operators, functions and conditions in 10g. June 2004

Measuring cpu time in 10g

Tue, 2004-06-22 03:00
An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004

Quoting string literals in 10g

Tue, 2004-06-22 03:00
Oracle 10g provides a quoting mechanism for strings that include single-quotes. June 2004

Partition outer join in oracle 10g

Tue, 2004-06-22 03:00
A new mechanism to populate the gaps in sparse data. June 2004

Data dump utility

Sun, 2004-02-22 02:00
Procedure to dump the contents of a table or the results of a query to flat file. February 2004

Merge counter

Sun, 2004-02-22 02:00
A package to capture and report separate INSERT and UPDATE rowcounts from a MERGE statement. February 2004

Introduction to bulk pl/sql enhancements in 9i

Mon, 2003-09-22 03:00
Oracle extends its array processing capabilities in 9i. September 2003

User-defined aggregate functions in oracle 9i

Mon, 2003-09-22 03:00
We can create our own aggregate functions in 9i and use them like built-ins. September 2003

Pages