how do I know number of results fetched by query?? Is there any method in ResultSet class ??
The difference between winner and loser is making things happen and letting things happen.
posted 15 years ago
Hi u dont have a method directly which gives u the Row count by a resultset.u can get the rowcount in oracle using count(*) for a query. well ,if u want to know the number of records fetched ,then use a local variable and keep it in loop thru while(rs.next) variable ++ print out the variable.