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: 9.0.5.2.0 to 11.1.1.2.0 - Release: AS10g to
Information in this document applies to any platform.

Goal

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>


Solution

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 hundreds of Community platforms