Joined: 12-October 05
Member No.: 3,107
In oracle, is there any way to get number of row selected after run a query? For example, using sql plus, after running select * from table_name, the last row of result is "x row selected". I know that Implicit cursors: SQL%ROWCOUNT returns number of rows affected by SQL statement, but it seems only effect to insert, update, delete sql statement.