ORA-00907: missing right parenthesis on query with subqueries and EXCEPT operator
EXCEPT is an SQL standard that is not available in Oracle. You probably want to use the Oracle equivalent of MINUS.
See here for a good answer on the two keywords.
Edit: @a_horse_with_no_name corrected thanks!