Oracle SQL - SQL*Plus Feedback

Introduction

SQL*Plus tells you how many rows it found in Oracle's NEWSPAPER table.

This is called feedback.

You can make SQL*Plus stop giving feedback by setting the feedback option, as shown here:

set feedback off 

Alternatively, you can set a minimum number of rows for feedback to work:

set feedback 25 

This last example tells Oracle that you don't want to know how many rows have been displayed until there have been at least 25.

Unless you tell SQL*Plus differently, feedback is set to 6.

Related Topics