sqlvariablessqlplusoracle-ebs

Suppress output of variables substitution in sqlplus

I'd like to suppress the output of such lines as the following ones

old   9: AND FROMDAT <= TO_DATE('&duedate', 'YYYYMMDD')
new   9: AND FROMDAT <= TO_DATE('20091031', 'YYYYMMDD')
old  10: AND TODAT > TO_DATE('&duedate', 'YYYYMMDD')
new  10: AND TODAT > TO_DATE('20091031', 'YYYYMMDD')

How could I achieve this?

TERM OFF and FEEDBACK OFF is already set.

Solution

  • SET VERIFY OFF is the answer.