Re: How to suppress Oracle old,new messages in SQLPLUS ?

>
> 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 Received on Sun Feb 03 2008 - 04:04:59 CST