Oracle set feedback, oraclefeedback

Oracle set feedback, oraclefeedback

1. set feedback on

Oracle will give feedback when an SQL statement is sent by default.
For example, execute the following table creation statement:

Create table t_test_lll (id varchar2 (10 ));

The command line returns Table created.
For example, when a pl/SQL statement is successfully stored, the command line returns:
PL/SQL procedure successfully completed.

2. set feedback off

When many statements are run in the script, if every piece of information is fed back, it is too messy.
In this case, you can run this command to set feedback to off to disable feedback.

3. set feedback n

When an SQL statement returns n or greater than n rows of records, feedback is returned.
For example: set feedback 10,
Then execute the following statement:

Select * from t_testlll;

If there are 97 statements in the t_testlll table, after the query result is returned, there will be a feedback of 97 rows selected.
If less than 5 rows are returned, no such feedback is returned.