Re: SQL*Plus - Hide "Connected" response to Connect

"Les Noll" <lnoll_at_netnitco.net> wrote in message news:TieRc.1817$Ow6.145236_at_newssvr28.news.prodigy.com...
> Thanks, I didn't think about appending the separate files but that is an
> option.
> +Les
> --
>
> ------------------------------------------------------------------------
> Lester L. Noll
> lesnoll_at_sbcglobal.net
> http://freepages.genealogy.rootsweb.com/~lnoll
> "Hans Forbrich" <forbrich_at_yahoo.net> wrote in message
> news:tG5Rc.66002$T_6.10919_at_edtnps89...
> > Les Noll wrote:
> >
> > > Thanks, Hans and Ana. Yes, I did search the manual first, and found
> > > nothing.
> > >
> > > SQLPLUS -S doesn't suppress the "Connected" response.
> > >
> >
> > The obvious 'hard way' is to have the output from each user go to a
> separate
> > file and then use an OS command to copy/append (such as unix !cat a b >>
> c)
> >
> > IIRC, Thomas Kyte mentioned something about this either in one of his
> books
> > or at http://asktom.oracle.com - you might try asking Tom
> >
> > /Hans
>
>

or maybe you can just grep the "connected" out ... something like this:

print "

   connect user/pass
   @sqlscript
   exit;
" | sqlplus -s /nolog | egrep -v '^Connected.$' > output.file

Anurag Received on Mon Aug 09 2004 - 20:12:40 CDT