Lines: 16
X-Admin: news@aol.com
From: uchakra@aol.com (Uchakra)
Newsgroups: comp.databases.oracle.server
Date: 04 Mar 2001 05:19:52 GMT
References: <983658011.241951@news.aei.ca>
Organization: AOL http://www.aol.com
Subject: Re: How to define Unix environment variables in the sql files
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