Search notes:

SQL*Plus: SET FEEDBACK

When feedback is enabled in SQL*Plus, SQL*Plus prints messages such as
With feedback set to off, the notification Connected is still displayed when using the connect command to establish a new connected.
I tend to disable feedback when executing SQL scripts because this feedback clutters the output.

N (number)

Setting feedback to a number displays the number of records returned if the number of records returns is greater or equal to the number set with set feedback n.
set feedback on sets this number to 1.

SQL_ID

With the sql_id option, executing an SQL statement reports the statement's sql id.
SQL> set feedback on sql_id
SQL> select count(*) from user_tables;

  COUNT(*)
----------
       231

1 row selected.

SQL_ID: gvbd2560h99pq

See also

set termout
set
SQL*Plus

Index