Search

OakieTags

more tags

Who's online

There are currently 0 users and 29 guests online.

Recent comments

Affiliations

Home

11g Articles

Profiling trace files with preprocessor external tables in 11g

Submitted by abb on Wed, 2011-11-09 07:37

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

Submitted by abb on Tue, 2010-06-01 11: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 18: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 18: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 18: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 19: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 20: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 18: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 19: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 17:01

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