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.