After you enter a value at the prompt, SQL*Plus lists the line containing the substitution variable twice: once before substituting the value you enter and once after substitution. You can suppress this listing by setting the SET command variable VERIFY to OFF.
You can define variables, called substitution variables, for repeated use in a single script by using the SQL*Plus DEFINE command. Note that you can also define substitution variables to use in titles and to save your keystrokes (by defining a long string as the value for a variable with a short name).
The NUMWIDTH setting controls the default width used when displaying numeric values.
SET VERIFY OFF
is the answer.
SET VERIFY OFF does suppress the parameter substitution dialogue, but it does not prevent the parameter entry (Enter value for..) chatter from being written to output.
However if you combine that with SET HEADING OFF you will have output that includes only return data with no garbage at the top.
I use this when I need to have a sqlplus program return XML output to an Oracle concurrent request.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With