Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: To know the number of results returned just after query ??

Re: To know the number of results returned just after query ??

From: Keith Jamieson <Keith.Jamieson_at_phoenix.ie>
Date: Fri, 3 Aug 2001 10:46:37 +0100
Message-ID: <9kdrlt$81l$1@kermit.esat.net>

What about v_rowcount := SQL%ROWCOUNT;

Jim Kennedy wrote in message ...
>Very expensive. You end up doing 2 queries of every one or retrieving the
>entire result set 2x.
>Jim
>"Isma" <Isma_at_iballo.com> wrote in message
>news:3B6958BF.1B0AFF3F_at_iballo.com...
>> Hi,
>>
>> I use a JDBC driver. I want to know whether exists a command to know the
>> results number just after the query.(i.e. lines)
>>
>> [I know it exists getColumnCount() to know the number of columns return
>> ..
>> int numcols = rsmd.getColumnCount();
>> ]
>>
>> stmt.execute(sql)
>> ResultSet rs = stmt.getResultSet();
>> ResultSetMetaData rsmd = rs.getMetaData();
>>
>>
>> What about getfetchSize() ??? it always return 10 whatever returned
>> results.
>>
>>
>
>
Received on Fri Aug 03 2001 - 04:46:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US