Hi all,
I'm having hard time in understanding this statement from the oracle docs about LATERAL inline view.
Do you know what this means?
"
Restrictions on LATERAL: Lateral inline views are subject to the following restrictions:
- If a lateral inline view contains the
query_partition_clause, and it is the right side of a join clause, then it cannot contain a left correlation to the left table in the join clause. However, it can contain a left correlation to a table to its left in the FROM clause that is not the left table. "