Re: initialising env var using sqlplus
From: Larry Prall <pralll_at_hfsi.com>
Date: Mon, 19 Sep 1994 08:29:52 GMT
Message-ID: <9409190429.AA52945_at_lmacq.hfsi.com>
Date: Mon, 19 Sep 1994 08:29:52 GMT
Message-ID: <9409190429.AA52945_at_lmacq.hfsi.com>
In article <355cor$n1c_at_nuscc.nus.sg>, med10054_at_nusunix2.nus.sg (NORHISHAM BIN
MAIN) writes:
> #! /bin/ksh OUT_DIR='OUT_DIR
> IN_DIR
> UL_DIR
> DL_DIR'
>
> for EACH_DIR in $OUT_DIR; do
> $EACH_DIR=`echo "set feedback off
> set heading off
> select $EACH_DIR
> from direcotories
> where hostname='MY_HOST';" | sqlplus -s /` done
>
> export $OUT_DIR
Try substituting:
for EACH_DIR in `echo $OUT_DIR`; do
That should work, while preserving the rest of your environment.
Larry Prall Received on Mon Sep 19 1994 - 10:29:52 CEST