Set verify command
457179Sep 29 2005 — edited Oct 12 2005Hi everyone,
Normally after the query, the database will printout the old and new query before displaying the result. However, i wish to remove the old query(bold) but not the new one.
By setting verify off, it will remove the old and new query, which does not solve my problem. Could anyone offer his/her help? iappreciate it alot. Thanks.
SQL> set verify on
SQL> define myv = 100
SQL> select last_name from employees where employee_id = &myv;
old : select last_name from employees where employee_id = &myv
new : select last_name from employees where employee_id = 100
LAST_NAME
-------------------------
King