Search

OakieTags

more tags

Who's online

There are currently 0 users and 4 guests online.

Recent comments

Affiliations

Home

11g Articles

Listagg function in 11g release 2

Submitted by abb on Tue, 2010-06-01 12:00

A new built-in function for string aggregation. June 2010

Query result cache in oracle 11g

Submitted by abb on Mon, 2010-01-04 19:38

Oracle adds a new cache for storing the results of queries. December 2007

Pivot and unpivot queries in 11g

Submitted by abb on Mon, 2010-01-04 19:05

Turn rows into columns and vice versa with new extensions to the SELECT statement. April 2008

Pl/sql enhancements in oracle 11g

Submitted by abb on Mon, 2010-01-04 19:01

Various minor language and operability enhancements for PL/SQL in 11g. May 2008

Dynamic sql enhancements in 11g

Submitted by abb on Fri, 2009-12-11 20:45

Oracle completes its dynamic SQL implementation for PL/SQL. February 2008 (updated June 2010)

Collect enhancements in 11g release 2

Submitted by abb on Mon, 2009-11-30 21:10

Aggregate unique and ordered collection elements with the COLLECT function in 11g. November 2009

Listing files with the external table preprocessor in 11g

Submitted by abb on Mon, 2009-11-02 19:11

Using the 11g external table preprocessor to get directory listings in SQL. October 2009

External table enhancements in 11g

Submitted by abb on Thu, 2009-10-15 20:21

Encryption, compression and preprocessing for external tables in Oracle 11g. September 2009

Virtual columns in 11g

Submitted by abb on Fri, 2008-10-10 18:01

Store expressions as virtual columns in Oracle 11g. October 2008

Regular expression enhancements in 11g

Submitted by abb on Tue, 2008-05-20 20:56

Oracle 11g adds a new REGEXP_COUNT function and extends some of the existing functions. May 2008