My Oracle Support Banner

What is the "QRSLT" Inline Query Generated by ADF BC ? (Doc ID 1079326.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle JDeveloper - Version: to - Release: AS10g to
Information in this document applies to any platform.


Using JDeveloper, you see that the query generated for your Read-Only View Object is generated
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 identifier
because 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>


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.