Last updated on MARCH 08, 2017
Applies to:Oracle JDeveloper - Version: 188.8.131.52.0 to 184.108.40.206.0 - Release: AS10g to
Information in this document applies to any platform.
like the following:
SELECT * FROM (<your View Object Query>) QRSLT
What is the QRSLT exactly ?
Is there a way to avoid its generation ?
This may lead to errors like
ORA-904: "<column_name>": invalid identifierbecause the SQL query that's generated is invalid, f.ex. when specifying a value in the ORDER BY:
SELECT * from (<your Query>) QRSLT where 1=2 ORDER BY <yourOrderBy>
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms