title: How to run SQL in shell script
body: <p>How do you run a SQL command in a shell script while setting a variable?  I had tried this method and it isn't executing the command, it is thinking the command is just a string.</p>
  
  <pre><code>#!/bin/ksh
  variable1=`sqlplus -s username/pw@oracle_instance &lt;&lt;EOF
  SET PAGESIZE 0 FEEDBACK OFF VERIFY OFF HEADING OFF ECHO OFF
  select count(*) from table;
  EXIT;
  EOF`
  if [ -z "$variable1" ]; then
    echo "No rows returned from database"
    exit 0
  else
    echo $variable1
  fi
  </code></pre>