Search

Top 60 Oracle Blogs

Recent comments

Oakies Blog Aggregator

Regular expressions in 10g

Oracle finally provides support for regular expressions. June 2004

Dual optimisation in 10g

The dual table gets a performance makeover. November 2004

Introduction to bulk pl/sql enhancements in 9i

Oracle extends its array processing capabilities in 9i. September 2003

Tracking exceptions in oracle 10g

Exceptions can now be traced back to their source in 10g. June 2004

Partition outer join in oracle 10g

A new mechanism to populate the gaps in sparse data. June 2004

Measuring cpu time in 10g

An addition to DBMS_UTILITY now enables us to measure CPU time easily. June 2004

Aggregating data with the returning clause

In 10g, data returned by the RETURNING clause can be aggregated. June 2004

Replacef

A function to simplify string building and debugging by replacing multiple placeholders from a collection of inputs. January 2007

Put_line

A simple wrapper to DBMS_OUTPUT.PUT_LINE to workaround the 255 byte limit (not needed from 10.2 onwards). April 2002

Call stack parser

A small package of functions for parsing the PL/SQL call stack. Includes an implementation of "WHOAMI" and "CALLER". September 2003