Oracle: order by subquery missing right parenthesis
- Joel Lipman
- Oracle PL/SQL
- Hits: 13366
A quick note on how I got round one this one.
Why?
Often enough, our requirement is that the latest record from another table is associated with the current row, and often enough we get the latest by ordering the dataset of the subquery. In T-SQL and MySQL, this is not so much of an issue.
I get this error when having to use an ORDER BY clause in a subquery within an Oracle 11g environment.
How?
Consider the following: