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

From: Paul Förster <paul.foerster_at_gmx.net>
Date: Sun, 3 Feb 2008 11:41:31 +0100
Message-ID: <60lk2rF1r8k9hU1@mid.individual.net>


Hi zw,

On 2008-02-03 07:23:35 +0100, zw <MPC8250_at_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.foerster_at_gmx.net
Received on Sun Feb 03 2008 - 04:41:31 CST

Original text of this message