title: Error while trying to mimic intersection
body: <p>I am trying to mimic the query(for academical purpose) </p>
  
  <pre><code>(select course_id from section where semester = 'Spring' and year = 2010) 
  intersect
  (select course_id from section where semester = 'Fall' and year = 2009)
  </code></pre>
  
  <p>Successfully mimicked with </p>
  
  <pre><code>select t.course_id from section t, section s where s.course_id = t.course_id and
  s.semester = 'Spring' and s.year = 2010 and t.semester = 'Fall' and t.year = 2009;
  </code></pre>
  
  <p>and when I tried these, </p>
  
  <pre><code>select t.course_id from section t, section s where s.course_id = t.course_id and
  (s.semester, s.year, t.semester,t.year) in ('Spring',2010,'Fall',2009);
  </code></pre>
  
  <blockquote>
    <p>error at the parenthesis after <code>in</code> predicate(as per the row and
    column mentioned in error), error is ORA-00920: invalid relational
    operator
    00920. 00000 -  "invalid relational operator"</p>
  </blockquote>
  
  <p>then I tried </p>
  
  <pre><code>select t.course_id from section t, section s where 
  s.course_id = t.course_id and (s.semester,s.year) = ('Spring',2010) 
  and (t.semester, t.year) in ('Fall',2009);
  
  
  select t.course_id from section t, section s where 
  s.course_id = t.course_id and ((s.semester,s.year) in ('Spring',2010)) 
  and ((t.semester, t.year) = ('Fall',2009));
  </code></pre>
  
  <p>with different combination of <code>in</code> and <code>=</code> getting the same error at parenthesis after the first <code>in</code> or <code>=</code></p>
  
  <p>Is there a limit in mentioning attributes for <code>(..) in/= (...)</code> or using the same table causes this or some other reason?</p>
  
  <p>using Oracle 12c.</p>