title: Run sql query from If else block in shell script
body: <p>I want to connect sql db and execute sql query from shell script. I tried using this</p>
  <pre><code>if float_cmp &quot;$size1 &gt; 7.50&quot;; then
      echo &quot;### THE DATA SIZE IS GREATER THAN 7.5 GB ###&quot;
      echo &quot;############### DROPPING CREATED $IMPUSER USER ###########################&quot;
      ${PATH_TO_CLIENT}sqlplus $EXPUSER/$EXPPWD@$ENDPOINT&lt;&lt; EOF
      drop user $IMPUSER cascade;
      exit;
      EOF
      exit 1
  else
      echo &quot;### THE DATA SIZE IS OKAY ###&quot;
  fi
  </code></pre>
  <p>The statement is working outside if block but throwing error when executing in IF block</p>
  <pre><code>line 80: warning: here-document at line 72 delimited by end-of-file (wanted `EOF')
  line 81: syntax error: unexpected end of file
  </code></pre>
  <p>Can anyone please tell what am I doing wrong and what is the solution?</p>