Before Oracle 9i Release 2, if we want to use the UTL_FILE package then we need to initialize UTL_FILE_DIR initialization [...]

[Read more →]

I collected some feedback about my earlier blog.
First Blog Link
Understanding Oracle Release Number Format
Second Blog Link
Understanding Oracle Release Number Format - 2
Comment From  [...]

[Read more →]

I was going through some papers about TNS Listener, so I though why not share what I know and what [...]

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

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 →]

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

[Read more →]

First have a look at following query:
SELECT e_name, age, address
FROM employees
WHERE UPPER(e_name) = ‘RAJENDER SINGH’;
Now, One of the important instruction [...]

[Read more →]