| You are printing a report for your boss, and the last page contains a line that tells how many rows were selected. You do not want this line on the report. |
SET FEEDBACK OFF |
| You are executing a script that happens to have a number of ampers and (&) characters in it, and SQL*Plus keeps prompting you for values. None of the ampersands are meant to indicate substitution variables. | SET DEFINE OFF |
| You spooled a report to a file and printed it. Each page seems to have two or three sets of page titles with about 20 rows of data between each. You need the titles to print just once per page. | SET PAGESIZE 66 |
| You've written a script for a group of end-users, but every time they run the script, they see the before and after images of lines containing substitution variables. You don't want them to see that because they keep calling you for an explanation. | SET VERIFY OFF |
| You need to debug a script and want to see each command as it is being executed. | SET ECHO ON |
| You are printing a report with some long text fields. Whenever a text field wraps to a second line, you get a blank line immediately following it. You don't want this blank line. | SET RECSEP OFF |
| You copied a spool file containing a report to a printer, and the printer did not advance to a new sheet of paper for each new page in the report. | SET VERIFY 0 |