SELECT E1.EMPNO,E2.EMPNO FROM (SELECT ROWNUM r1,empno FROM emp ORDER BY empno DESC)e1,(SELECT ROWNUM r2,empno FROM emp ORDER BY empno ASC) [...]

[Read more →]

Today I came across this thread at Oracle Forum.
Where Question was as follows:
Consider Test table have Numb (Number datatype) field. [...]

[Read more →]

Today when doing some research on “FAST DUAL”, I came across following error when I try to set autotrace on:
SQL> [...]

[Read more →]

On 13th October 2007, I wrote about “Understanding Virtual Columns“.
Then Ray DeBruyn ask me a very good question, which I [...]

[Read more →]

On 12th july 2007, I wrote a post about new feature of 11g related to sequence.
In this post I mention [...]

[Read more →]

I don’t why but I never came across this function, may be because I am so used to using MOD [...]

[Read more →]

Scenario From Oracle Forum
I have a transaction table consists of duplicate records I success to write a sql
which get the [...]

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

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