Re: cursors and sql%rowcount

Use rownum. select * from table_name where rownum<11 will get you 10 rows.

kal121_at_my-deja.com wrote:
: Hi,
 

: I have a cursor that can return one or several hundred rows at a time.
 

: The thing is, I only ever want just the first row. Right now I'm
: executing the cursor in a FOR LOOP. Then, IF SQL%ROWCOUNT = 1, I get the
: values for the first row returned then halt executing of the loop with a
: RETURN statement.
 

: It's just that this seems a clunky way to do this. Is there any other
: way to limit the result set?
 

: The sql statement does not lend itself to limiting output,
: unfortunately. And I cannot use ROWID for this purpose, as the data
: retrieved by the cursor is not necessarily sequential.
 

: thanks

: Sent via Deja.com http://www.deja.com/
: Before you buy.
  Received on Fri Mar 03 2000 - 00:00:00 CST