title: EXCEPT keyword in Oracle
body: <p>I'm trying to use the EXCEPT keyword in Oracle 10.1.0.2.0, but kept getting error 'Unknown Command'. I've tried googling around and someone said the keyword is MINUS, so I used MINUS, instead, but I still got the same error. 
  Any idea?
  Thanks.</p>
  
  <p>So here's my query. 
  I'm finding the name of students who enrolls in ALL courses with course number > 500</p>
  
  <pre><code>SELECT s.name
  FROM Students s
  WHERE NOT EXISTS
    (
      SELECT c.id
      FROM Courses c
      WHERE c.number &gt; 500
  
      MINUS
  
      SELECT e.course_id
      FROM Enrollment e
      WHERE e.student_id = s.id
    );
  </code></pre>