New features in Oracle 11G :
11g new feature articles Oracle 11g
expands on the automation and advisor framework of 10g, but also
includes a wide range of performance and optimization 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
For any enquiry leave your details here for call back :
http://seedinfotechwagholi-pune.co.in/enquiry.phpFor more details visit SEED Infotech Wagholi Pune Blog at :
http://seedinfotechpune.blogspot.in/Locate us on Google Map :
https://www.google.co.in/maps/place/SEED+Infotech+Pune/@18.580642,73.976231,15z/data=!4m2!3m1!1s0x0:0xc4d19be6006792c9?sa=X&ei=-dFUVMiFFcGLuwT6qIL4BA&ved=0CHwQ_BIwCgGoogle+ :
https://plus.google.com/+SeedinfotechwagholipuneCoIn412207/postsWordPress –
http://seedinfotechpune.wordpress.com