Hi

why rownum always have to use with less than operator. Like

[Email Address Removed] select EMPLOYEE_ID,rownum from employee where rownum < 4;

EMPLOYEE_ID
-----------
7499
7505
7506

But following query does not return data.
1)
[Email Address Removed] select EMPLOYEE_ID,rownum from employee where rownum > 4;

no rows selected.
2)
[Email Address Removed] select EMPLOYEE_ID,rownum from employee where rownum = 4;

no rows selected.

Plz any one can me valid reason for it.

and one more

It is possible to create view based on non-exist table .


Thanks in advance

With Regards,
Rekha.


Oracle LazyDBA home page