According to Using Subqueries Oracle SQL accepts a subquery in the from-clause of a select statement, like
SELECT * FROM ( SELECT a FROM b );
However, looking at the SELECT documentation, I see no possibility to get to select/subquery in the from clause (e.g. from the rules table_reference
or join_clause
).
Am I missing something here, is this part of the SQL grammar documented elsewhere? Or is this another incomplete part of the documentation?
In the documentation you linked, you can see that table_reference
can be a query_table_expression
which can be a ( subquery )
.