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

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