Oracle Set Feedback

First, set feedback on

By default, Oracle gives a feedback when a SQL is issued.
For example, execute the following CREATE TABLE statement:

CREATE TABLE t_test_lll (ID varchar2 (10));

The Command Guild returns: Table created.
For example, when performing a PL/SQL storage success, the command line returns:
PL/SQL procedure successfully completed.

Second, set feedback off

When you run a lot of statements in a script, it's too messy to feed each piece of information back.
You can then execute this command and set feedback to off to turn off the feedback information.

Third, set feedback n

When an SQL statement returns n or more than n rows of records, there is feedback.
For example: Set Feedback 10,
Then execute the following statement:

SELECT * from T_testlll;

There are 97 statements in the T_testlll table, then, after returning the results of the query, there will be: Selected rows feedback.
If the return row is less than 5, there is no feedback.

Oracle Set Feedback