How to suppress Oracle old,new messages in SQLPLUS ?

[usenet]

Hi

I have the following:

shell script A.sh
--------------------------
nohup ./B.sh $ts $locate $5 $7 $3 $4 $9 &



shell script B.sh
------------------------

:
:
while 1
sqlplus -s $5/$6@$7 @c.sql $3 >> fc1
end


When I tail -f fc1, I get

old 1: select count(*) from v$session a where a.username='&1' and
a.status='AC
TIVE'
new 1: select count(*) from v$session a where a.username='test' and
a.status='ACTIVE'

0

I just want to see 0 appended to fc1 file.


Thanks

[usenet]

>
> I have the following:
>
> shell script A.sh
> --------------------------
> nohup ./B.sh $ts $locate $5 $7 $3 $4 $9 &
>
>
>
> shell script B.sh
> ------------------------
>
> :
> :
> while 1
> sqlplus -s $5/$6@$7 @c.sql $3 >> fc1
> end
>
>
> When I tail -f fc1, I get
>
> old 1: select count(*) from v$session a where a.username='&1' and
> a.status='AC
> TIVE'
> new 1: select count(*) from v$session a where a.username='test' and
> a.status='ACTIVE'
>
> 0
>
> I just want to see 0 appended to fc1 file.
>

Try : SET VERIFY OFF

[usenet]

Hi zw,

On 2008-02-03 07:23:35 +0100, zw said:
> old 1: select count(*) from v$session a where a.username='&1' and
> a.status='ACTIVE'
> new 1: select count(*) from v$session a where a.username='test' and
> a.status='ACTIVE'
>
> 0

.... make yourself familiar with the "show" and "set" options of the
sqlplus command. Read the "Oracle SQL*Plus User's Guide and
Reference"...
--
cul8er

Paul
paul.foerster@gmx.net