Suppress output of variables substitution in sqlplus

sql variables sqlplus
user321068 picture user321068 · Mar 17, 2011 · Viewed 40.8k times · Source

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.

Answer

user321068 picture user321068 · Mar 17, 2011

SET VERIFY OFF is the answer.

Related questions

How to declare variable and use it in the same Oracle SQL script?

I want to write reusable code and need to declare some variables at the beginning and reuse them in the script, such as: DEFINE stupidvar = 'stupidvarcontent'; SELECT stupiddata FROM stupidtable WHERE stupidcolumn = &stupidvar; How can I declare a variable …

Read More
MySQL: @variable vs. variable. What's the difference?

In another question I posted someone told me that there is a difference between: @variable and: variable in MySQL. He also mentioned how MSSQL has batch scope and MySQL has session scope. Can someone elaborate on this for me?

Read More
How do I use variables in Oracle SQL Developer?

Below is an example of using variables in SQL Server 2000. DECLARE @EmpIDVar INT SET @EmpIDVar = 1234 SELECT * FROM Employees WHERE EmployeeID = @EmpIDVar I want to do the exact same thing in Oracle using SQL Developer without additional complexity. It seems like …

Read More