Top 60 Oracle Blogs

Recent comments

9i Articles

Case expressions and statements in oracle 9i

Extended CASE expressions and the new CASE statement in 9i. May 2002

Multilevel collections in oracle 9i

Oracle 9i supports collections of collections of collections... October 2002

Multi-table inserts in oracle 9i

We can now insert into multiple tables from a single statement. October 2002

Decomposing sql%rowcount for merge

A method for getting insert and update counts from a MERGE operation. August 2003

External tables in oracle 9i

Select directly from flat-files as though they are tables. August 2002 (updated June 2007)

Subquery factoring in oracle 9i

A new way of expressing subqueries in 9i. December 2005 (updated June 2007)

Ansi joins in oracle 9i

Oracle adds ANSI-compliant joins to SQL in 9i. January 2003 (updated June 2007)

Type enhancements in oracle 9i

Constructor functions, type evolution and substitution in 9i. December 2005 (updated June 2007)

Pipelined functions in oracle 9i

Functions can now stream data as virtual tables. May 2002 (updated May 2007)

Anydata and anytype in 9i

An introduction to generic types in Oracle 9i. October 2002 (updated July 2007)