Today I had a situation at my client’s place which I need to tackle as soon as possible and I [...]

[Read more →]

Yesterday suddenly I received a call from my guys that one of the database server at my client’s place  has [...]

[Read more →]

Recently after I configured database on testing machine and configure the forms to run on middle tier on testing machine [...]

[Read more →]

Recently while doing R&D, I came across the ADR Command Interpreter (ADRCI).
Introduced in Oracle Database Release 11g, it is a [...]

[Read more →]

Yesterday I was doing some r&d and tried to find trace file for my session.
After lot of trouble I was [...]

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

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

Today I came up with this challenge of creating UNIQUE index on a table with exiting non unique value. After [...]

[Read more →]