Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

User-defined aggregate functions in oracle 9i

We can create our own aggregate functions in 9i and use them like built-ins. September 2003

The merge statement in oracle 9i

Update or insert data from a single DML statement in 9i. September 2002

Associative arrays in oracle 9i release 2

Oracle extends its PL/SQL array processing capabilities. May 2002

Merge enhancements in 10g

Enhancements to the MERGE statement in 10g provide much greater flexibility. June 2004

Enhancements to dbms_output in 10g release 2

Oracle finally "fixes" DBMS_OUTPUT. August 2005

Flashback restore points in oracle 10g release 2

Restore points enable us to capture a point in time for flashback operations. August 2005

Flashback table in 10g

Oracle extends flashback technology to restore dropped tables. June 2004

Flashback query in oracle 9i

We can now query data from a previous point in time. November 2002

Array-based advanced queuing in 10g

Oracle 10g enables us to enqueue and dequeue in bulk. July 2005

Pl/sql timer

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