Feedback settings in SQLPLUS

Feedback settings in SQLPLUS

When SQL plus is used to execute an SQL statement, a prompt such as "XX rows have been returned" may be returned for the result returned by a SELECT statement, but this prompt is not found when a database is opened recently. According to master @ Qiao Xiaoyang, there is a feedback parameter setting, which is summarized as follows.

Feedback can be abbreviated as feed. It has three values: ON/OFF/N. ON indicates opening SQL feedback (DDL is slightly different from DML and PLSQL), and OFF indicates disabling feedback, N indicates that an integer can be set. If the return value of an SQL statement is greater than or equal to N, feedback is returned.

Lab:

1. query results with the feed being OFF and ON:

2. Check the default settings of the feed. If the returned six rows are returned, the feedback is displayed. You can execute the SQL statement to describe this point:

3. Set feed N and specify to return N rows for feedback:

Summary:

Any small link in Oracle contains a wealth of knowledge points, and different results have different reasons. This reflects the charm of Oracle as the boss and can only sigh that it is too small, you need to learn too much!

Oracle Study Notes: sqlplus User Logon

Sqlplus ORA-01017 when logging on to Oracle: invalid username/password; logon denied Error

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian