title: Oracle multiple fields in Select IN Parameter
body: <pre><code>Select * FROM STUDENT 
  WHERE (student.course, student.major) IN (SELECT schedule.course, schedule.major 
  FROM schedule) 
  </code></pre>
  
  <p>What if i have to provide static values, what would be the query like?  Because I am passing the SQL from a middle layer based on input parameters.</p>
  
  <p>Edit: I am looking to search based on multiple sets of values.  For ex.</p>
  
  <pre><code>Select * FROM STUDENT 
  WHERE (student.course, student.major) IN 
  (('MBA', 'Computers'), ('BA', 'Computers'))
  </code></pre>