Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: get parameter from unix shell pgm

Re: get parameter from unix shell pgm

From: Authorised User <bp_at_bp.com>
Date: 1997/11/04
Message-ID: <01bce910$ae9e74e0$022266a1@eusunw2415.rec.bp.com>#1/1

if you are calling sqlplus inside the unix shell program...like

...
sqlplus username/password_at_host_string
....

then you can do
...
sqlplus $1/$2@$3
...
where $1..3 are the parameter passed to the shell program.

or do it in single go
..
sqlplus $1
...
Then $1 would be like username/password_at_host_string ..

you have to call your script as
scriptname username/password_at_host_string

GRPronet <grpronet_at_aol.com> wrote in article <19971103042100.XAA13639_at_ladder02.news.aol.com>...
> i need to read in parameters coming in from a unix shell pgm.
> (username,password,host string) into sqlplus. how do i do it?
> gil.
>
Received on Tue Nov 04 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US