9i new feature articles
I'm pleased to announce that I've been selected as a finalist in the inaugural Oracle Database Developer Choice Awards. To quote, these awards "celebrate and recognize technical expertise and contributions in the Oracle Database community".
I've been selected for the PL/SQL category, primarily for the articles and utilities that I share here on oracle-developer.net. I'm very pleased to be recognised by the Oracle Community in this way and if you have found oracle-developer.net to be a helpful and/or interesting resource, then I'd appreciate your vote (my voting page is here).
More information on the Awards, including an explanatory video, the rules, other categories and finalists can all be found on the main page.
Thanks for your support!
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