Just putting into words what I understand about how Oracle database handles the reading and writing of data.
Did some brain [...]

[Read more →]

As per my experience when working with PL/SQL code, DBMS_OUTPUT is one of the most frequently used package to display [...]

[Read more →]

Check out following:
SQL> select * from test;
COL1
———-
[...]

[Read more →]

Recently at my client place I implemented RMAN script for maintenance of backups through RMAN, so that my team don’t [...]

[Read more →]

In this blog entry let me introduce you to a new capability in Oracle 10g called Block Change Tracking, which [...]

[Read more →]

When working with virtual columns recently I came across the following error:
ORA-30553: The function is not deterministic
Cause: The function on [...]

[Read more →]

For last few days I was busy packing my things plus doing some important task related to my Australia trip [...]

[Read more →]

Just trying to brush up few basic concept!
What happens when Oracle processes an SQL Statement?

Step 1: Oracle Create a Cursor
For [...]

[Read more →]

Recently I came across term called Virtual Index or some call it fake indexes. I will use term Virtual Index [...]

[Read more →]

Today I faced the problem of Oracle Forms 6i failing to connect to Oracle XE 10g on my colleague’s laptop.
I [...]

[Read more →]