Home » SQL & PL/SQL » Client Tools » Suprime message Old and New SQLPlus (SQLPlus, Oracle9i)
icon5.gif  Suprime message Old and New SQLPlus [message #279277] Wed, 07 November 2007 10:32 Go to next message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
Hi,
I need suprime message Old and New in output list

For example:

sql> column dummy new_value c1
sql> select dummy from dual;
D
=
X
sql> select * from dual where dummy='&c1';
old 1: select * from dual where dummy='&c1'
new 1: select * from dual where dummy='X'


I need only show:
sql> select * from dual where dummy='&c1';
D
=
X


Thanks
Re: Suprime message Old and New SQLPlus [message #279286 is a reply to message #279277] Wed, 07 November 2007 10:47 Go to previous messageGo to next message
pablolee
Messages: 2835
Registered: May 2007
Location: Scotland
Senior Member
I don't know what suprime means but I assume that you want to 'switch off' the old/new.
set verify on/off
Re: Suprime message Old and New SQLPlus [message #279293 is a reply to message #279286] Wed, 07 November 2007 10:58 Go to previous message
tony_pe
Messages: 17
Registered: August 2007
Junior Member
It's correct (good)
Thanks
Previous Topic: Formating output of a query in html ?
Next Topic: Can't initialize OCI error occured during the login process using TOAD 9.0
Goto Forum:
  


Current Time: Fri Dec 09 07:50:24 CST 2016

Total time taken to generate the page: 0.10628 seconds