title: Declaration of multiple values in Oracle BIND Variables
body: <p>I am trying to pass multiple values about 3000 values, to a BIND variable in Oracle SQL PLUS command prompt like..</p>
  
  <pre><code>SELECT JOB
    FROM EMP 
   WHERE JOB IN :JOB -- bind variable value
  </code></pre>
  
  <p>I want to see my result, as all the values in <code>EMP</code> table on column <code>JOB</code> matching to that variable list has to be fetched out.</p>
  
  <hr>
  
  <p>As its being production environment I can't create tables only I have grant on SELECT clause.</p>
  
  <p>Need more information on how exactly it get executed when I run the same query from UNIX-SQL PLUS environment.</p>
  
  <p>Will it prompt asking to enter the BIND variables values or can I refer to a file which has values as...
  :JOB1 := 'MANAGER'
  :JOB2 := 'CLERK'
  :JOB3 := 'ACCOUNTANT'</p>