Quantcast
OracleBrains.Com header image 5

Entries Tagged as 'Oracle 11g New Features'

PL/SQL: Fine Grained Dependency Tracking

September 11th, 2007 · 1 Comment

In previous releases, metadata recorded mutual dependencies between objects with the granularity of the whole object.
For example:
PL/SQL unit P [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read more →]

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 [...]

[Read 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 [...]

[Read more →]

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 [...]

[Read more →]

Tags: Oracle 11g New Features · SQL and PL/SQL