Cleaning Up the Display
As you’ve followed the development of the LIST_INDEXES script, you no doubt saw the following lines interspersed in the output:
old 9: AND ui.table_name = UPPER('&table_name')
new 9: AND ui.table_name = UPPER('project_hours')
...
6 rows selected.
Commit complete.These lines add no value to the script and serve only to clutter up the output. It would be nice to get rid of them, and it is possible to do that by turning verification and feedback off. The commands to do that are described next.
Turning Verification Off
Verification refers to what SQL*Plus does when it encounters a line of script containing substitution variables. By default, SQL*Plus verifies the substitution by displaying both the old and the new versions of the line involved. The output from verification looks like this:
old 9: AND ui.table_name = UPPER('&table_name')
new 9: AND ui.table_name = UPPER('project_hours')Sometimes this verification is useful, especially when you are first developing a script, because it allows you to see for sure whether or not your substitutions are being made correctly. Once you’ve developed a script, though, it’s nice to be able to turn this output off.
You can turn verification off by adding the following command to your script:
SET VERIFY OFF
Turning verification off makes your output a lot cleaner, and is especially helpful if the script is a report that may be run by an end user.
Turning Feedback Off
Feedback refers to the short messages that SQL*Plus ...