Oracle SQL*Plus: The Definitive Guide, 2nd Edition

Name

SET FEEDBACK

Synopsis

The FEEDBACK setting controls whether SQL*Plus displays the number of records returned by a SELECT statement, deleted by a DELETE statement, updated by an UPDATE statement, or inserted by an INSERT statement. You can set a threshold, below which you don't get any feedback regardless of whether the setting is on.

Syntax

SET FEED[BACK] {OFF | ON | row_threshold}

Parameters

SET FEED[BACK]

Is the command, which may be abbreviated SET FEED.

OFF

Turns off feedback completely. SQL*Plus won't tell you how many rows are affected by any SQL statements you issue.

ON

Turns on feedback, and is equivalent to SET FEEDBACK 1. For any SQL statement you issue, SQL*Plus will tell you how many rows were affected. By default, feedback is on with a threshold of 6 rows.

row_threshold

Allows you to specify a row threshold, and also turns feedback on if it is not already on. A row threshold causes SQL*Plus to print the row count returned by a SELECT statement when that row count exceeds the threshold. The row threshold applies only to the SELECT statement. As long as feedback is on, the INSERT, DELETE, and UPDATE statements always return the number of rows affected, regardless of the row threshold.

Examples

The following example shows a feedback message from a SELECT statement:

SQL> SET FEEDBACK 1
SQL> SELECT * FROM dual;
D
-
X
1 row selected.

In this example, feedback was set to 1 prior to executing the SELECT statement. That caused a feedback message to be displayed even though the statement ...