Feed aggregator

Merge enhancements in 10g

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

Flashback table in 10g

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

Tracking exceptions in oracle 10g

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

Regular expressions in 10g

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

Collection extensions in 10g

Adrian Billington - 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

Adrian Billington - 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

Adrian Billington - 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

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

Data dump utility

Adrian Billington - 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

Adrian Billington - 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

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

User-defined aggregate functions in oracle 9i

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

Call stack parser

Adrian Billington - Mon, 2003-09-22 03:00
A small package of functions for parsing the PL/SQL call stack. Includes an implementation of "WHOAMI" and "CALLER". September 2003

Decomposing sql%rowcount for merge

Adrian Billington - Fri, 2003-08-22 03:00
A method for getting insert and update counts from a MERGE operation. August 2003

Flashback query in oracle 9i

Adrian Billington - Fri, 2002-11-22 02:00
We can now query data from a previous point in time. November 2002

Multilevel collections in oracle 9i

Adrian Billington - Tue, 2002-10-22 03:00
Oracle 9i supports collections of collections of collections... October 2002

Multi-table inserts in oracle 9i

Adrian Billington - Tue, 2002-10-22 03:00
We can now insert into multiple tables from a single statement. October 2002

The merge statement in oracle 9i

Adrian Billington - Sun, 2002-09-22 03:00
Update or insert data from a single DML statement in 9i. September 2002

Case expressions and statements in oracle 9i

Adrian Billington - Wed, 2002-05-22 03:00
Extended CASE expressions and the new CASE statement in 9i. May 2002

Associative arrays in oracle 9i release 2

Adrian Billington - Wed, 2002-05-22 03:00
Oracle extends its PL/SQL array processing capabilities. May 2002

Pages

Subscribe to Oracle FAQ aggregator