Re: hi alll......How can i connect to oracle9i db and fetch the data from specific tables using shell script

On Dec 5, 11:39 am, "gazzag" <gar..._at_jamms.org> wrote:
> sybrandb wrote:
> > If you know Unix shell scripting, you must be aware you can use
> > <env var>=`sqlplus username/password_at_service @script`
>
> > provided you have
> > set newpage 0 pagesize 0 feedback off
> > in your script.
>
> > Hth
> > --
> > Sybrand Bakker
> > Senior Oracle DBAAdditionally, call SQL*Plus with its "-s" flag.
>
> HTH
>
> -g

Yes, you are right. Sorry, I forgot.
But IIRC, if you also want to suppress the 'Connected' message, you need to use /nolog and -s simultaneously, and issue a connect statement in your code (which is advantageous, as it will hide your password)

-- 
Sybrand Bakker
Senior Oracle DBA