Connecting Tech Pros Worldwide Help | Site Map

Sqlplus (set verify command)

  #1  
Old June 27th, 2008, 08:02 PM
losway
Guest
 
Posts: n/a
Hi everyone

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

Original
SQLset verify o
SQLdefine myv = 10
SQLselect last_name from employees where employee_id = &myv
old : select last_name from employees where employee_id = &my
new : select last_name from employees where employee_id = 10

LAST_NAM
------------------------
King

Require
SQLset verify o
SQLdefine myv = 10
SQLselect last_name from employees where employee_id = &myv
new : select last_name from employees where employee_id = 10

LAST_NAM
------------------------
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 o
query will be changed automatically. If by using print statements
the user has to change both the query and the print statements, henc
not robust

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

Los

  #2  
Old June 27th, 2008, 08:02 PM
Altasen.com
Guest
 
Posts: n/a

re: Sqlplus (set verify command)


Hi losway

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

HT

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

Closed Thread