ORACLE MULTIPLE CTE STATEMENTS code example

Example: ORACLE MULTIPLE CTE STATEMENTS

WITH    cte1 AS
        (
        SELECT  1 AS id
        ),
        cte2 AS
        (
        SELECT  2 AS id
        )
SELECT  *
FROM    cte1
UNION ALL
SELECT  *
FROM    cte2
UNION ALL
SELECT  *
FROM    cte1