feedback is enabled in SQL*Plus, SQL*Plus prints messages such as select statements (231 rows selected)
PL/SQL procedure successfully completed.)
Table created etc.) feedback set to off, the notification Connected is still displayed when using the connect command to establish a new connected. set feedback n. set feedback on sets this number to 1. 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