9i new feature articles
Oracle 9i was a great release for developers, especially for those in high-volume environments. A selection of articles, covering new features from both of the two major 9i releases, is available below.
- Anydata and anytype in 9i
An introduction to generic types in Oracle 9i. October 2002 (updated July 2007) - Type enhancements in oracle 9i
Constructor functions, type evolution and substitution 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) - Subquery factoring in oracle 9i
A new way of expressing subqueries in 9i. December 2005 (updated June 2007) - External tables in oracle 9i
Select directly from flat-files as though they are tables. August 2002 (updated June 2007) - Pipelined functions in oracle 9i
Functions can now stream data as virtual tables. May 2002 (updated May 2007) - User-defined aggregate functions in oracle 9i
We can create our own aggregate functions in 9i and use them like built-ins. September 2003 - Introduction to bulk pl/sql enhancements in 9i
Oracle extends its array processing capabilities in 9i. September 2003 - Decomposing sql%rowcount for merge
A method for getting insert and update counts from a MERGE operation. August 2003 - Flashback query in oracle 9i
We can now query data from a previous point in time. November 2002 - Multi-table inserts in oracle 9i
We can now insert into multiple tables from a single statement. October 2002 - Multilevel collections in oracle 9i
Oracle 9i supports collections of collections of collections... October 2002 - 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 - Case expressions and statements in oracle 9i
Extended CASE expressions and the new CASE statement in 9i. May 2002