11g 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 11g expands on the automation and advisor framework of 10g, but also includes a wide range of performance and optimisation improvements. This release seems to be more tailored to stability and change management than ever before and there is a huge number of new features to consider. A selection of articles on new features for developers are available below.
- External table enhancements in 11g
Encryption, compression and preprocessing for external tables in Oracle 11g. September 2009 (updated June 2014)
- Query result cache in oracle 11g
Oracle adds a new cache for storing the results of queries. December 2007 (updated June 2014)
- Profiling trace files with preprocessor external tables in 11g
Generate and read TKProf and OraSRP reports in a single SQL*Plus window (or other IDE of choice) using preprocessor external tables. November 2011
- Listagg function in 11g release 2
A new built-in function for string aggregation. June 2010
- Dynamic sql enhancements in 11g
Oracle completes its dynamic SQL implementation for PL/SQL. February 2008 (updated June 2010)
- Pl/sql function result cache in 11g
Oracle provides a cross-session cache for user-defined PL/SQL function results. January 2008 (updated June 2010)
- Collect enhancements in 11g release 2
Aggregate unique and ordered collection elements with the COLLECT function in 11g. November 2009
- Listing files with the external table preprocessor in 11g
Using the 11g external table preprocessor to get directory listings in SQL. October 2009
- Virtual columns in 11g
Store expressions as virtual columns in Oracle 11g. October 2008
- Regular expression enhancements in 11g
Oracle 11g adds a new REGEXP_COUNT function and extends some of the existing functions. May 2008
- Pl/sql enhancements in oracle 11g
Various minor language and operability enhancements for PL/SQL in 11g. May 2008
- Pivot and unpivot queries in 11g
Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008
- Subprogram inlining in 11g
Oracle extends the scope of its PL/SQL compiler optimisation. November 2007
- Pls-00436 removed in oracle 11g
Oracle relaxes the long-standing FORALL implementation restriction in 11g. November 2007