2009-09-01

Oracle 11g release 2

The Linux versions is already available!
Link for the documentation.


The PL/SQL features for 11g Release 2 (11.2) are:

* DBMS_PARALLEL_EXECUTE Package
* FORCE Option in CREATE TYPE Statement
* Crossedition Triggers
* ALTER TYPE Statement Restrictions for Editioned ADTs
* RESET option for ALTER TYPE Statement
* Automatic Detection of Data Sources of Result-Cached Function
* Result Caches in Oracle RAC Environment Are No Longer Private
"

SQL: "The following built-in functions are new or enhanced in this release:

* For a specified measure, the function LISTAGG orders data within each group specified in an ORDER BY clause and then concatenates the values of the measure column.
* A new NTH_VALUE function returns the value of a measure in a specified row of a window of data.
(...)
* The subquery_factoring_clause now supports recursive subquery factoring (recursive WITH), which lets you query hierarchical data. This feature is more powerful than CONNECT BY in that it provides depth-first search and breadth-first search, and supports multiple recursive branches. A new search_clause and cycle_clause let you specify an ordering for the rows and mark cycles in the recursion.
(...)

have fun!

No comments:

Post a Comment

Os comentários são moderados.
The comments are moderated.