SQLPLUS feedback settings, sqlplusfeedback

SQLPLUS feedback settings, sqlplusfeedback

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 where the feed is OFF and ON:

2. view the default settings of the feed. If 6 is returnedWhen you run the SQL statementL this can be explained:

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!

Your access failed
Oracle Database sqlplus settings

Right-click the sqlplus window (blue bar), and click Properties... Set it by yourself. You can do whatever you want.
The console window is like this