Re: SQLPLUS: How can I stop echoing &1 value in SQLPlus tool

Use the SET SHOW OFF disable to print the old part of the line .

SHOW[MODE] {OFF|ON} Controls whether SQL*Plus lists the old and new settings of a SQL*Plus system variable when you change the setting with SET. ON lists the settings; OFF suppresses the listing. SHOWMODE ON has the same behavior as the obsolete SHOWMODE BOTH

Bye
Andrea

Syed Salman Shakir wrote:

> Hi All,
> I've written an sql script as follows
>
> select *
> from TABLE
> where column1 = &1
> and column2 = 'N'
> and column3 ='CONNECT'
> order by ACTDATE;
>
> I saved it in a file and executed it from the SQL prompt as follows
>
> SQL> _at_filename 1010000
>
> When this command executes, first it displays the old and new value of
> &1 as follows
>
> old 4: where custnum = &1
> new 4: where custnum = 1010001
>
> and then display the resulting values.
>
> My question is how could I prevent my self from this OLD and NEW value
> echo?
> I dont want this echo. I need only the resulting values.
>
> Thanks in advance.
>
> Best Regards,
> Salman
>
Received on Mon Dec 13 1999 - 14:13:44 CET