How to suppress Oracle old,new messages in SQLPLUS ?

[zw]

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

[astalavista]

Try : SET VERIFY OFF

[Paul Förster]

Hi zw,

On 2008-02-03 07:23:35 +0100, zw <MPC...@gmail.com> 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.f...@gmx.net

[jeff...@gmail.com]

@Paul: RTFM. Thanks *so* much for your assistance.

[joel garry]

On Nov 13, 1:34 pm, jefftb...@gmail.com wrote:
> @Paul:  RTFM. Thanks *so* much for your assistance.

@Jeff: Look at the date of the message you are replying to.

jg
--
@home.com is bogus.
http://www.wired.com/techbiz/people/magazine/16-12/ff_kaminsky?currentPage=all

[Eric]

On 2012-11-14, joel garry <joel-...@home.com> wrote:
> On Nov 13, 1:34?pm, jefftb...@gmail.com wrote:
>> @Paul: ?RTFM. Thanks *so* much for your assistance.

>
> @Jeff: Look at the date of the message you are replying to.
>
> jg
> --
> @home.com is bogus.
> http://www.wired.com/techbiz/people/magazine/16-12/ff_kaminsky?currentPage=all

Only 4 and a half years old! The worst case I've seen was 14 years.
Sadly, this sort of thing is getting more and more common.

Eric
--
ms fnd in a lbry

[joel garry]

On Nov 14, 12:10 am, Eric <e...@deptj.eu> wrote:

> On 2012-11-14, joel garry <joel-ga...@home.com> wrote:
>
> > On Nov 13, 1:34?pm, jefftb...@gmail.com wrote:
> >> @Paul: ?RTFM. Thanks *so* much for your assistance.
>
> > @Jeff: Look at the date of the message you are replying to.
>
> > jg
> > --
> > @home.com is bogus.

> >http://www.wired.com/techbiz/people/magazine/16-12/ff_kaminsky?curren...

>
> Only 4 and a half years old! The worst case I've seen was 14 years.
> Sadly, this sort of thing is getting more and more common.
>
> Eric
> --
> ms fnd in a lbry

It's sad, but isn't it merely ignorance or even just a mistake, rather
than stupidity? Ignorance is fixable, everyone makes mistakes,
especially with new features (like being able to answer 14 year old
messages, or search engines directing into forum knowledge bases with
no expire dates). My inner optimist wants to guide the desire of
these people to help towards a positive goal, but I can't quite see
how.

jg
--
@home.com is bogus.

http://www.theregister.co.uk/2012/11/12/oracle_launches_redpatch_repository/