title: Crontab Unix Shell Script EOF
body: <pre><code>sqlplus -s u@t/t &lt;&lt; EOF
  drop table connection_backup;
  CREATE TABLE connection_backup AS (SELECT * FROM connection);
  drop table htbill_backup;
  CREATE TABLE htbill_backup AS (SELECT * FROM htbill);
  EXIT
  EOF
  
  Crontab -e File
  */1 * * * * sh ~/sql.sh | write $LOGNAME
  </code></pre>
  
  <p>due to the eof in first line crontab stops over their and does not execute further shell script</p>