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>
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.netReceived on Sun Feb 03 2008 - 04:41:31 CST