Fun with Oracle DB: ORA-00907

21 Mar 2012

Following SQL select statement

 
select * from A a
where a.id in (select b.id from B b order by b.id)

leads to an error message:

 
> ORA-00907: missing right parenthesis

Hm. I don't see anything missing... Ok, let's remove the order clause, as it is not really needed:

 
select * from A a
where a.id in (select b.id from B b)

No ORA-00907. I am not the only one having these troubles, see the blog post by oraclequirks.