Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Set verify command

457179Sep 29 2005 — edited Oct 12 2005
Hi 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 9 2005
Added on Sep 29 2005
8 comments
2,589 views