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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to define Unix environment variables in the sql files

Re: How to define Unix environment variables in the sql files

From: Uchakra <uchakra_at_aol.com>
Date: 04 Mar 2001 05:19:52 GMT
Message-ID: <20010304001952.10403.00000478@ng-cs1.aol.com>

It's done easily using a shell script.
May be you have a different requirement, howwver, following is a small Ksh script.
cat test.ksh

#!/bim/ksh
export xx=5
sqlplus -s userid/password <<EOF
select count(*) from emp where
empno = $xx
exit
EOF test.skh

Regards Received on Sat Mar 03 2001 - 23:19:52 CST

Original text of this message

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