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