Unix + oracle connection

UNIX for Advanced & Expert Users
1

Requirements:

Using a shell script I have to check the 4 values from a table in Oracle and then store the result as "Y" in a Unix variable if the values are desired and "N" if the values are not desired.

Explanation:

There is a table abc in oracle which has 4 fields. if all the four values comes out to be 1 then i want to assign a Unix variable "result" as "Y".

If even one of the values is "0" then i want to assign the UNIX variable "result" as "N".

All this has to be done using UNIX shell scripting.

Request the experts to come ahead and help me.

Decci

2

One way -

sqlplus -s username/passwd@oracledb<<EOF
set head off
set feedback off
spool tmp.tmp
select fld1 + fld2 + fld3 + fld4 from abc;
spool off
exit
EOF
result=0
grep -q '4' tmp.tmp
if [[ $? -eq 0 ]] ; then
  result=1
fi
3

jim, would it not print wrong if the values were 4,0,0,0 ?