Re: returning the number of rows.

On 17 Jun 2005 21:38:58 -0700, "DaLoverhino" <DaLoveRhino_at_hotmail.com> wrote:

>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.

SET FEEDBACK <N>

Any number below <N> will not be displayed. The default is 6 To get feedback always, use
set feedback 1

To disable it
set feedback off

--
Sybrand Bakker, Senior Oracle DBA