Sqlplus (set verify command)

[losway]

Hi everyone,

Firstly i would like to thank everyone for their help and
suggestions.
However, i still could not fulfil my boss request. Here what i need to
do:

Original:
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
Required
SQL> set verify on
SQL> define myv = 100
SQL> select last_name from employees where employee_id = &myv;
new : select last_name from employees where employee_id = 100

LAST_NAME
-------------------------
King

I only want the 'new query' to be printed out. That is all.
And im not supposed to use print statements to print out the query.
Which means whenever the user changes the query, the printout of
query will be changed automatically. If by using print statements,
the user has to change both the query and the print statements, hence
not robust.

Could anyone help me? i appreciate your help very much. Thanks in
advance.
Lost

[Altasen.com]

Hi losway,

as far as I know this it not possible. It is all or no verify
information.

HTH

Roel Hogendoorn
More information on Oracle Apps or Tech Oracle can be found on:
http://www.altasen.com