WITH T AS ( SELECT 'STC_AQSSTP_003' AS LC_STEP , 'N' AS STRTR_ID , 'STC_AQSSTP_002' AS HGRNK_LC_STEP , 'N' AS HGRNK_STRTR_ID FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'N', 'STC_AQSSTP_003', 'N' FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'NA', 'STC_AQSSTP_003', 'NA' FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'NA01', 'STC_AQSSTP_003', 'NA01' FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'NA02', 'STC_AQSSTP_003', 'NA01' FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'NA03', 'STC_AQSSTP_003', 'NA01' FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'NA02', 'STC_AQSSTP_003', 'NA02' FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'NA03', 'STC_AQSSTP_003', 'NA03' FROM DUAL UNION SELECT 'STC_AQSSTP_004', 'NA04', 'STC_AQSSTP_003', 'NA04' FROM DUAL ) SELECT * FROM T
위 테이블을
STC_AQSSTP_002 STC_AQSSTP_003 STC_AQSSTP_004
N N N
NA NA
NA01 NA01
NA02
NA03
NA02 NA01
NA02
NA03 NA01
NA03
NA04 NA04
로 출력하고 싶습니다.
어렵게 다가가서 그런지 해결이 안되서.. ㅜㅜ
고수님들 조언부탁드립니다.