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

"Hans Forbrich" <forbrich_at_yahoo.net> wrote in message news:h7XRc.75000$T_6.45254_at_edtnps89...
> Anurag Varma wrote:
>
> > 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
> >
>
> You assume he's on a real OS. What's the WIndows equiv? ;-)
> /H
>
>

For windows/dos, perl can be of help.... :) something like
sqlplus -s /nolog @sqlscript | perl -pe "s/^Connected.$//g"

which would work in both windows and unix (provided perl is installed)

Anurag Received on Tue Aug 10 2004 - 18:18:09 CDT