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