| Query [message #39283] |
Wed, 03 July 2002 00:32  |
bharath
Messages: 30
Registered: November 2000
|
Member |
|
|
hai,
I have used a cursor which will contain nearly 2lacks of records.
How can i display results based on record numbers.
for eg:
suppose mycur contains 2 lacks records
now i want to display only 20 records and then 40 records
like wise
thanks in advance
bharath
|
|
|
|
| Re: Query [message #39288 is a reply to message #39283] |
Wed, 03 July 2002 06:52  |
 |
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
use rownum.
1* select rownum,ename from emp where rownum < =3
SQL>
SQL> /
ROWNUM ENAME
---------- ----------
1 SMITH
2 ALLEN
3 WARD
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
