WITH T AS (
SELECT '한국' COUNTRY  , '11-13' DT1 , '11-15' DT2 , '11-77' DT3 FROM DUAL
)

-- 행복제
SELECT COUNTRY
     , CASE WHEN LEVEL = 1 THEN DT1 
                WHEN LEVEL = 2 THEN DT2
                WHEN LEVEL = 3 THEN DT3
        END DT
     , CASE WHEN LEVEL = 1 THEN '날짜1' 
                WHEN LEVEL = 2 THEN '날짜2' 
                WHEN LEVEL = 3 THEN '날짜3' 
        END DT_GB
  FROM T CONNECT BY LEVEL <= 3 

-- UNPIVOT
SELECT COUNTRY , DT ,  DT_GB
  FROM T 
UNPIVOT ( DT FOR DT_GB IN (DT1 AS '날짜1' , DT2 AS '날짜2', DT3 AS '날짜3' ))