Originally posted by varshanswamy
the erroe i get is ERROR at line 1:
ORA-00907: missing right parenthesis
"order by" is not permitted in in-line views in 8.0.5, I believe.