Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Sqlplus (set verify command)

Sqlplus (set verify command)

From: losway <losway_at_gmail-dot-com.no-spam.invalid>
Date: Wed, 19 Oct 2005 02:11:41 -0500
Message-ID: <tLqdndMi85QwbMjeRVn_vA@giganews.com>


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 Received on Wed Oct 19 2005 - 02:11:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US