title: How to pass variables in sqlplus in bash command
body: <p>Here is may problem : I have inline sqlplus call in my bash file and I would like to pass it a parameter</p>
  
  <p>this code is what I'm trying</p>
  
  <pre><code>c_id=`sqlplus -S $login/$password  $id &lt;&lt; EOF
      set pagesize 0
      set verify off
      set head off
      set feedback off
      SELECT id from bdd.table where ID not in (select id from bdd.TMP_table) and id &gt; &amp;1 and ROWNUM &lt;= 1000 order by id;
      exit;
      EOF`
  </code></pre>
  
  <p>how can I use my $id parameter in my where statement (&amp;1)?</p>