Oracle set feedback, oraclefeedback

Source: Internet
Author: User

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.

 

 

 

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.