When querying in Oracle, use ROWNUM pseudocolumn to limit the number of
returned rows. Pseudocolumns behave like table columns but are not
actually stored in tables.

For example:
SELECT firstname FROM employee
WHERE ROWNUM < 10 ;

Here are the results:
FIRSTNAME
------------
John
Tim
Julie
Stacy
Rahul
Leena
Amy
Bill
Teri

George W. Seelig
Database Administration
Computer Science Corporation / BAE Systems CNIR
450 Pulaski Road, Greenlawn, New York 11740
Tel:(631) 912-1619, Building 5, Floor 2, MS 5-45

-----Original Message-----
From: Rajkumar
[mailto:oracledba-ezmlmshield-x30495749.[Email address protected]
Sent: Thursday, May 11, 2006 12:13 PM
To: LazyDBA Discussion
Subject: use of RowNum

Hi EveryBody,



Can nybody tell me what is use of RowNum in Oracle.



Regards

Raj





--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page