Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to define Unix environment variables in the sql files
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