Fun with Oracle DB: ORA-00907

Following SQL select statement leads to an "ORA-00907: missing right parenthesis" warning message:

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

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)

And, voilà! No ORA-00907. And it seems that I am not the only one having these troubles, see the blog entry by oraclequirks.