Pl/sql timer

Uncategorized
| Jul 8, 2005
A simple package to output the elapsed time between two points. Supports versions from 8i onwards. July 2005

Unloading data using external tables in 10g

Uncategorized
| May 24, 2005
External tables can write as well as read in 10g. May 2005

Dual optimisation in 10g

Uncategorized
| Nov 25, 2004
The dual table gets a performance makeover. November 2004

Sql tuning advisor in 10g

Uncategorized
| Nov 15, 2004
Oracle now offers SQL tuning recommendations. November 2004

Row-generation without i/o

Uncategorized
| Nov 11, 2004
Methods for generating dummy data without incurring I/O costs. November 2004

Flashback table in 10g

Uncategorized
| Jun 30, 2004
Oracle extends flashback technology to restore dropped tables. June 2004

Measuring cpu time in 10g

Uncategorized
| Jun 26, 2004
An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004

Aggregating data with the returning clause

Uncategorized
| Jun 26, 2004
In 10g, data returned by the RETURNING clause can be aggregated. June 2004

Collection extensions in 10g

Uncategorized
| Jun 22, 2004
A brief overview of the new collection operators, functions and conditions in 10g. June 2004

Regular expressions in 10g

Uncategorized
| Jun 22, 2004
Oracle finally provides support for regular expressions. June 2004

Tracking exceptions in oracle 10g

Uncategorized
| Jun 21, 2004
Exceptions can now be traced back to their source in 10g. June 2004

Exception enhancements in 10g

Uncategorized
| Jun 15, 2004
A few small enhancements to exception handling/error messages. June 2004

Merge enhancements in 10g

Uncategorized
| Jun 13, 2004
Enhancements to the MERGE statement in 10g provide much greater flexibility. June 2004

Native dynamic sql optimisation in 10g

Uncategorized
| Jun 7, 2004
Native dynamic SQL gets an optimisation to match DBMS_SQL for efficiency. June 2004

Forall enhancements in 10g

Uncategorized
| Jun 5, 2004
An overview of enhancements to FORALL bulk-binding. June 2004

Quoting string literals in 10g

Uncategorized
| Jun 5, 2004
Oracle 10g provides a quoting mechanism for strings that include single-quotes. June 2004

Partition outer join in oracle 10g

Uncategorized
| Jun 1, 2004
A new mechanism to populate the gaps in sparse data. June 2004

Data dump utility

Uncategorized
| Feb 28, 2004
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

Data dump utility

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