I find Difference between %NOTFOUND & NO_DATA_FOUND. post by S. Inderjeet Singh quite interesting.
So I decided to research on it [...]

[Read more →]

Theoretically saying %NOTFOUND is a cursor attribute which returns TRUE if the last FETCH statement retrieved no record and FALSE [...]

[Read more →]

First introduce in Oracle 9i, ANYDATA is a “self describing data instance type” which means it not only holds the [...]

[Read more →]

This post is in response to Metalized view by MAhmad
Views
A view is a logical entity. It is a SQL statement [...]

[Read more →]

What is Metalized view ? What are the differences between normal view and metalized view?

Bookmark this post

[...]

[Read more →]

Today I came across one intersting topic called Enhancements in Oracle 11g PL/SQL.Some of the interesting features that I got [...]

[Read more →]

When doing research for Internal Datatypes in Oracle I though of sharing and publising following information with the guys who [...]

[Read more →]

One more important term which really stuck me while writting “Understanding Internal DATE Storage” post, was “Internal Datatype”. Although the [...]

[Read more →]

Today I came across one interesting question at Oracle Forum
Dear experts!
Please help me with this kind of query!
Suppose that I [...]

[Read more →]

I was little bit curious about DUMP function after writting Understanding Internal DATE Storage. So I did little bit reserach [...]

[Read more →]