From: xux@informa.bio.caltech.edu (Xuequn Xu)
Subject: Re: cursors and sql%rowcount
Date: 2000/03/03
Message-ID: <89p3dk$ak3@gap.cco.caltech.edu>#1/1
References: <89ovce$qbo$1@nnrp1.deja.com>
Organization: California Institute of Technology, Pasadena
Newsgroups: comp.databases.oracle.server


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

kal121@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.