Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Please enter a title.
You can not post a blank message. Please type your message and try again.
Oracle Community (OTN)
This discussion is archived
on Aug 1, 2012 6:34 PM by Beth Roeser-Oracle
Documentation 11g 2 ?
Jul 30, 2012 4:52 PM
The documentation on http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_8004.htm#SQLRF54788
Restriction on the subquery_restriction_clause
You cannot specify this clause if you have specify an ORDER BY clause.
But i can successfully create a view with an order by clause in the subquery with read only or check option,
is the documentation false or is my interpretation of the documentation wrong?
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: Documentation 11g 2 ?
Aug 1, 2012 6:34 PM
in response to
In this case, the "cannot" means that you shouldn't do this because the results cannot be guaranteed. It doesn't mean that the database will return an error.