Adrian Billington
Articles and utilities available at oracle-developer.net
Updated: 45 min 33 sec ago
Pl/sql enhancements in oracle 11g
Various minor language and operability enhancements for PL/SQL in 11g. May 2008
Sql tuning advisor in 10g
Oracle now offers SQL tuning recommendations. November 2004
Pivot and unpivot queries in 11g
Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008
Dynamic logging with global application context
Controlling logging output across sessions using global application context. September 2007
Pipelined function issues
A few "gotchas" to be aware of when using pipelined functions. September 2007
Pl/sql function result cache in 11g
Oracle provides a cross-session cache for user-defined PL/SQL function results. January 2008
Row-generation without i/o
Methods for generating dummy data without incurring I/O costs. November 2004
Query result cache in oracle 11g
Oracle adds a new cache for storing the results of queries. December 2007
Pipelined functions in oracle 9i
Functions can now stream data as virtual tables. May 2002 (updated May 2007)
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)
Emulating string-to-table functionality using sql
Turning delimited strings into multiple records without PL/SQL. July 2005 (updated August 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)
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)
Sql plan enhancements in 10g
New plan features in 10g make SQL performance investigations much more simple. December 2004 (updated November 2007)
Pl/sql optimisation in 10g
Oracle 10g's compiler optimisation for faster PL/SQL, with a new section on optimisation bugs. November 2004 (updated March 2008)
Native dynamic sql optimisation in 10g
Native dynamic SQL gets an optimisation to match DBMS_SQL for efficiency. June 2004
Flashback version query in oracle 10g
We can now view the evolution of our data with flashback version query. August 2005