June 1, 2010
Recursive WITH Clause in Oracle 11g
Oracle Provided a new command in SELECT syntax. Following is what is mentioned in the help
——————————————————
The SQL WITH clause has been extended to enable formulation of recursive queries.
Recursive WITH clause complies with the American National Standards Institute (ANSI) standard. This makes Oracle ANSI-compatible for recursive queries.
For More info Click Here
Happy Learning
December 25, 2009
New Features in Oracle 11g : Caching and Pooling
Another good article on Caching and Pooling.
I was looking for the caching feature in 2005 as one of my select statement used to call a function more then 5 times with the same parameters. Any how “Better late than never”
December 15, 2009
New Features in Oracle 11g : Compound Triggers, Changing Trigger’s firing Order
Another new feature of Oracle 11g, this time on PL/SQL. This feature is really good. We can have compound triggers on a table, we can set the order in which the triggers should fire and many more.
December 4, 2009
New Features in Oracle 11g : SQL Operations: Pivot and Unpivot
Recently I came across the Pivot and Unpivot functions in Oracle 11g. Here is the link