RE: Sqlplus--how to suppress "Connected."

Thanks for the example.
Case closed :)

• Kirti

> -----Original Message-----
> From: Vladimir Begun [SMTP:jester_at_whale.sunbay.crimea.ua]
> Sent: Wednesday, June 27, 2001 11:47 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Sqlplus--how to suppress "Connected."
>
> On Jun 27, 2001 at 08:01:03AM, Deshpande, Kirti wrote:
> > hps1 [DBOP]: sqlplus -s /nolog
> > set feedback off
> > connect / as sysdba
> > Connected.
> > NEXT !!! :)
>
> [0][box:pts006][~](8) >sqlplus -S /NOLOG @dummy
> Emulating...
>
> SLOGAN
> ---------------------------
> I'm doing something usefull
>
> [0][box:pts006][~](9) >
> [0][box:pts006][~](9) >cat dummy.sql
> REM dummy.sql
> WHENEVER SQLERROR EXIT WARNING
> SET TERMOUT OFF
> SPOOL /dev/null
> CONNECT /
> SPOOL OFF
> SET TERMOUT ON
> WHENEVER SQLERROR CONTINUE
> PROMPT Emulating...
> SELECT 'I''m doing something usefull' SLOGAN FROM dual;
> EXIT;
>
> --
> Vladimir Begun | Of course, this being Perl, we could always
> http://vbegun.net/ | take both approaches. :-)
> http://vbegun.net/wap/ | -- Larry Wall in
> me_at_vbegun.net |
> <199709021744.KAA12428_at_wall.org>
> --
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: kirti.deshpande_at_verizon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).