In previous releases, metadata recorded mutual dependencies between objects with the granularity of the whole object.
For example:
PL/SQL unit P [...]
Entries Tagged as 'Oracle 11g New Features'
PL/SQL: Fine Grained Dependency Tracking
September 11th, 2007 · 1 Comment
Tags: Oracle 11g New Features
PL/SQL::New FOLLOWS Clause
September 4th, 2007 · 2 Comments
Before Oracle 11g, the order in which triggers of same type fire was arbitrary without any underlying principle or logic.
But [...]
Tags: Oracle 11g New Features
PL/SQL::New PL/SQL SIMPLE_INTEGER DATA TYPE
August 29th, 2007 · No Comments
Checked the New PL/SQL SIMPLE_INTEGER data type, found following facts about it:
SIMPLE_INTEGER is a predefined subtype of the PLS_INTEGER data [...]
Tags: Oracle 11g New Features · SQL and PL/SQL
SQL Tuning Tip::Invisible Indexes
August 20th, 2007 · No Comments
Few days back I wrote about virtual indexes which help us in checking the impact of indexes on SQL query [...]
Tags: Oracle 11g New Features · SQL and PL/SQL
Interval Partitioning: A new partitioning strategy in Oracle Database 11g
July 13th, 2007 · 1 Comment
One more features which really look interesting and I will be looking forward to implement it is, A new partitioning [...]
Tags: Oracle 11g New Features
PL/SQL: Sequences
July 12th, 2007 · 4 Comments
In Oracle, the sequences object provides a sequential series of numbers to applications without the overhead of disk I/O or [...]
Tags: Oracle 11g New Features
Oracle 11g (Beta) New Features
April 22nd, 2007 · No Comments
After what I find yesterday (Enhancements in Oracle 11g PL/SQL), I research more about Oracle 11g. Found out few more [...]
Tags: Oracle 11g New Features · Oracle Administration · Oracle Database
Can we use sequence in plsql
January 2nd, 2007 · No Comments
Today when checking “Search Keyphrases†for my site, I found out that someone wants to know about ‘can we use [...]
Tags: Oracle 11g New Features · SQL and PL/SQL
Enhancements in Oracle 11g PL/SQL
December 15th, 2006 · 3 Comments
Today I came across one intersting topic called Enhancements in Oracle 11g PL/SQL.Some of the interesting features that I got [...]





