Oracle DatabaseRecursive Sub-Query Factoring using the WITH Clause (A.K.A. Common Table Expressions)


Remarks

Recursive sub-query factoring is available in Oracle 11g R2.