RE: Limit no of recs in cursor
- From: "Naveen, Nahata (IE10)" <Naveen.Nahata@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 17 Mar 2004 01:28:21 -0700
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@xxxxxxxxxxxxx [mailto:manoj.gurnani@xxxxxxxxxxxxx]
>Sent: Wednesday, March 17, 2004 1:27 PM
>To: oracle-l@xxxxxxxxxxxxx
>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
>
>
>
>
>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
