9i Articles

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

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

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

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

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

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

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

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

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

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