Thanks for the example.
Case closed :)
- Kirti
> -----Original Message-----
> From: Vladimir Begun [SMTP:[EMAIL PROTECTED]]
> 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
> [EMAIL PROTECTED] |
> <[EMAIL PROTECTED]>
> --
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deshpande, Kirti
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
