Oracle SQL - SQL Plus FEEDBACK variable

  1. HOME
  2. Oracle SQL
  3. SQL Plus
  4. SQL*Plus Feedback

Introduction

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
SQL>

Related Topic