returning the number of rows.

Is there a way in sqlplus to return the number of rows fetched every time a select statement ends? For instance:

SQL> select * from pets; --pets is a small table with less than 20 rows
[Some output]
(13 rows returned)

For some unknown reason, sometimes sqlplus shows the rows returned, sometimes it doesn't.

thanks. Received on Fri Jun 17 2005 - 23:38:58 CDT