oracle oracle-developer.net 參考網站
2009/08/14 00:02
瀏覽1,022
迴響0
推薦1
引用0
介紹了很多有關oracle的文章
從8i~11g都有
http://www.oracle-developer.net/11g.php
Store expressions as virtual columns in Oracle 11g. October 2008
Oracle 11g adds a new REGEXP_COUNT function and extends some of the existing functions. May 2008
Various minor language and operability enhancements for PL/SQL in 11g. May 2008
Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008
Oracle completes its dynamic SQL implementation for PL/SQL. February 2008
Oracle provides a cross-session cache for user-defined PL/SQL function results. January 2008
Oracle adds a new cache for storing the results of queries. December 2007
Oracle extends the scope of its PL/SQL compiler optimisation. November 2007
Oracle relaxes the long-standing FORALL implementation restriction in 11g. November 2007
10g
Alternative IN-list binding in 10g using the new MEMBER OF collection condition. June 2004 (updated September 2008)
Modify partitions without invalidating dependant objects. October 2007 (updated August 2008)
Using the new 10g COLLECT group function, including string aggregation. June 2004 (updated July 2008)
Oracle 10g's compiler optimisation for faster PL/SQL, with a new section on optimisation bugs. November 2004 (updated March 2008)
New plan features in 10g make SQL performance investigations much more simple. December 2004 (updated November 2007)
Performance characteristics of DML error logging. August 2005
A new error logging mechanism for bulk DML statements. August 2005
Restore points enable us to capture a point in time for flashback operations. August 2005
Oracle finally "fixes" DBMS_OUTPUT. August 2005
Autotrace now uses DBMS_XPLAN to output its explain plans. August 2005
We can now view the evolution of our data with flashback version query. August 2005
Oracle 10g enables us to enqueue and dequeue in bulk. July 2005
External tables can write as well as read in 10g. May 2005
Oracle now offers SQL tuning recommendations. November 2004
The dual table gets a performance makeover. November 2004
Exceptions can now be traced back to their source in 10g. June 2004
Oracle extends flashback technology to restore dropped tables. June 2004
A new mechanism to populate the gaps in sparse data. June 2004
Oracle 10g provides a quoting mechanism for strings that include single-quotes. June 2004
Enhancements to the MERGE statement in 10g provide much greater flexibility. June 2004
Native dynamic SQL gets an optimisation to match DBMS_SQL for efficiency. June 2004
An overview of enhancements to FORALL bulk-binding. June 2004
An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004
In 10g, data returned by the RETURNING clause can be aggregated. June 2004
A few small enhancements to exception handling/error messages. June 2004
A brief overview of the new collection operators, functions and conditions in 10g. June 2004
Oracle finally provides support for regular expressions. June 2004
9i
An introduction to generic types in Oracle 9i. October 2002 (updated July 2007)
Constructor functions, type evolution and substitution in 9i. December 2005 (updated June 2007)
Oracle adds ANSI-compliant joins to SQL in 9i. January 2003 (updated June 2007)
A new way of expressing subqueries in 9i. December 2005 (updated June 2007)
Select directly from flat-files as though they are tables. August 2002 (updated June 2007)
Functions can now stream data as virtual tables. May 2002 (updated May 2007)
We can create our own aggregate functions in 9i and use them like built-ins. September 2003
Oracle extends its array processing capabilities in 9i. September 2003
A method for getting insert and update counts from a MERGE operation. August 2003
We can now query data from a previous point in time. November 2002
We can now insert into multiple tables from a single statement. October 2002
Oracle 9i supports collections of collections of collections... October 2002
Update or insert data from a single DML statement in 9i. September 2002
Oracle extends its PL/SQL array processing capabilities. May 2002
Extended CASE expressions and the new CASE statement in 9i. May 2002
你可能會有興趣的文章：
