show feedback : feedback « SQL PLUS Session Environment « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. SQL PLUS Session Environment
  3. feedback
SQL>
SQL>
SQL>
SQL> show feedback
FEEDBACK ON for 10 or more rows
SQL> /
drop table employees
           *
ERROR at line 1:
ORA-00942: table or view does not exist








29.8.feedback
29.8.1.'feedback' shows how many records were selected if it exceeds a certain amount
29.8.2.set feedback 100;
29.8.3.set feedback on/off
29.8.4.set feedback 4
29.8.5.show feedback