SET FEEDBACK

Syntax

SET FEEDBACK ON|OFF|<num>;

Description

Controls the output of confirmations. This includes the output after statements such as "INSERT INTO" and display of the row number in the output of a table. "OFF" suppresses the output of all confirmations, "ON" switch all confirmations on. If <num> is a numeric value greater than 0, tables with at least <num> rows will have row numbers displayed. The "SET VERBOSE OFF" statement and the command line parameter "-q" sets this setting to "OFF".

Examples

SQL_EXA> set feedback off;
SQL_EXA> insert into ty values (44,'Schmitt');
SQL_EXA> select * from ty;

Results

A B
11 Meier
44 Schmitt