| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Limit no of recs in cursor
Hi,
I want to process the remaining recs also.
How can I achieve the below logic:
I.e if 5 lakh recs in cursor,the pl/sql script should pick 1 lakh recs in
cursor.
The next time I execute the same script,it should pick the next 1 lakh
recs.
Thanks
Manoj
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Naveen, Nahata (IE10)
Sent: Wednesday, March 17, 2004 1:58 PM
To: oracle-l_at_freelists.org
Subject: RE: Limit no of recs in cursor
by using a WHERE clause?
If you already have a where clause in your query, then append the following:
AND rownum < 100
>-----Original Message-----
>From: manoj.gurnani_at_polaris.co.in [mailto:manoj.gurnani_at_polaris.co.in]
>Sent: Wednesday, March 17, 2004 1:27 PM
>To: oracle-l_at_freelists.org
>Subject: Limit no of recs in cursor
>Importance: High
>
>
>Hi All,
> I have a cursor which retrieves recs in lakhs .
>How can I limit the no of recs in the cursor.
>
>
>Thanks
>Manoj
>
>
>
>
>
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Wed Mar 17 2004 - 02:26:36 CST---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
- text/plain attachment: InterScan_Disclaimer.txt
 |
 |