Oracle SQL - SQL Plus FEEDBACK variable


FEEDBACK variable is a switch, you can set it to ON or OFF.

It is also a threshold value, where we set it to 4 in the following code.

SQL> select * from departments;

SQL> set feedback 4
SQL> /

SQL> select * from emp;
SQL> set  feedback off
SQL> show feedback
feedback OFF
SQL> /
SQL> set feedback 10

Related Topic