Search notes:
Oracle: Complex View Merging
Constructs preventing views from being merged
Some constructs may prevent a view from being (complex-) merged:
The outer query does not have a rowid or unique column
The view appears in a
connect by
query block
The view contains
grouping sets
,
rollup
or
pivot
clauses
Index