OraFAQ Forum: Client Tools » Suprime message Old and New SQLPlus

Home » Other » Client Tools » Suprime message Old and New SQLPlus (SQLPlus, Oracle9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Suprime message Old and New SQLPlus [message #279277]

Wed, 07 November 2007 10:32

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

Report message to a moderator