WITH TEST1 AS (
    SELECT 'value1' A_DATA,  'value2' B_DATA,  'value3' C_DATA,  'value4' D_DATA FROM DUAL
)
SELECT 'A_DATA' CULUMN1, A_DATA CULUMN2 FROM TEST1 UNION ALL
SELECT 'B_DATA' CULUMN1, B_DATA CULUMN2 FROM TEST1 UNION ALL
SELECT 'C_DATA' CULUMN1, C_DATA CULUMN2 FROM TEST1 UNION ALL
SELECT 'D_DATA' CULUMN1, D_DATA CULUMN2 FROM TEST1

 만약 자주 사용하는 경우가면 print_table프로시져를 이용해보세요

http://orapybubu.blog.me/40021496289 에서 프로시져를 다운받아 실행시키시고

아래 방법으로 실행시키시면 됩니다.

set serveroutput on 

exec print_table('쿼리문');

set sertveroutput off

WITH TEST1 AS (
    SELECT 'value1' A_DATA,  'value2' B_DATA,  'value3' C_DATA,  'value4' D_DATA FROM DUAL
)
SELECT
 CASE WHEN LEVEL =1 THEN A_DATA
      WHEN LEVEL =2 THEN B_DATA
      WHEN LEVEL =3 THEN C_DATA
      WHEN LEVEL =4 THEN D_DATA
 END  VAL    
 
from TEST1
CONNECT BY LEVEL <=4