Oracle DUAL 테이블로 다중 row 조회 방법

UNION ALL

SELECT
    *
FROM (
    SELECT 'DATA11' AS COLUMN1, 'DATA12' AS COLUMN2, 'DATA13' AS COLUMN3 UNION ALL
    SELECT 'DATA21' AS COLUMN1, 'DATA22' AS COLUMN2, 'DATA23' AS COLUMN3 UNION ALL
    SELECT 'DATA31' AS COLUMN1, 'DATA22' AS COLUMN2, 'DATA33' AS COLUMN3
) TABLE_NAME

CONNECT BY

SELECT 
    CASE
        WHEN LEVEL = 1 THEN 'DATA11'
        WHEN LEVEL = 2 THEN 'DATA21'
        WHEN LEVEL = 3 THEN 'DATA31'
    END AS COLUMN1,
    CASE
        WHEN LEVEL = 1 THEN 'DATA12'
        WHEN LEVEL = 2 THEN 'DATA22'
        WHEN LEVEL = 3 THEN 'DATA32'
    END AS COLUMN2,
    CASE
        WHEN LEVEL = 1 THEN 'DATA13'
        WHEN LEVEL = 2 THEN 'DATA23'
        WHEN LEVEL = 3 THEN 'DATA33'
    END AS COLUMN3
FROM 
    DUAL
CONNECT BY
    LEVEL <= 3