UNIX for Dummies Questions & Answers

how to pass values from oracle sql plus to unix shell script

... by searching the forums first.

#!/bin/ksh
#
# Oracle and UNIX
#
uid="userid"
pwd="password"
dbms="remote.com"
parm=" 'A1234' "

list=`sqlplus -s <<EOF
$uid/$pwd
set heading off
set pagesize 0
set tab off
SELECT zipcode
FROM companies@$dbms
WHERE company_code=$parm
/
exit
EOF`

for item in $list
do
echo "Output=" $item
done
#
# end of script

There is a good example in the Forum using co-process
You can also try this script for small list type output
Please note that the parameter must be enclosed in single quotes
So there is a double quote surrounding A1234 which is in single quotes