unix shell script to check result of sql query

Question

I have the code like this

v_use_xref_result=`sqlplus -s $UP <

   Select Code_Desc 
   From Code_Detail 
   Where Code='UXLOC' 
   and CODE_TYPE='UXRF'
       EOF`
 if [ "$v_use_xref_result" == "Y" ];  then
  echo "s"  else
  echo "n"
    fi

when I query the same in sql developer I am getting the result as Y for this query Select Code_Desc From Code_Detail Where Code='UXLOC' and CODE_TYPE='UXRF' the datatype of Code_Desc is varchar but I am unable to check in if condition. i am getting "n" as result for this script. can anyone help me how to check it in if condition.

devnull · Accepted Answer · 2013-10-09 12:25:30Z

1

As written, the heredoc syntax in your script doesn't seem to be correct. Try saying:

v_use_xref_result=$(sqlplus -s $UP <<EOF
   Select Code_Desc 
   From Code_Detail 
   Where Code='UXLOC' 
   and CODE_TYPE='UXRF'
EOF
)

answered Oct 9, 2013 at 12:25

devnull

124k33 gold badges247 silver badges234 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

unix shell script to check result of sql query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related