안녕하십니까, 아래 쿼리 개선 부탁드립니다

TEST_TABLE(테이블Name)

........

with ITEM_LIST as (
select 'PRT_DT' as ITEM_COL 
     , '2024-08-06'    as VAL
  from dual
select 'ITEM_NM' as ITEM_COL 
     , 'AAA'    as VAL
  from dual
union all  
select 'COL_A' as ITEM_COL 
     , '90'    as VAL
  from dual
union all
select 'COL_B' as ITEM_COL 
     , 'Y'     as VAL
  from dual
union all
select 'COL_D' as ITEM_COL 
     , 'Y'     as 
  from dual  
union all
select 'COL_F' as ITEM_COL 
     , 'Y'
  from dual  
)
select decode(b.ITEM_COL, 'PRT_DT', nvl2(b.ITEM_COL, b.VAL, ''), '') as ITEM_COL
     , decode(b.ITEM_COL, 'ITEM_NM', nvl2(b.ITEM_COL, b.VAL, ''), '') as ITEM_NM
     , decode(b.ITEM_COL, 'COL_A', nvl2(b.ITEM_COL, b.VAL, ''), '') as COL_A
     , decode(b.ITEM_COL, 'COL_B', nvl2(b.ITEM_COL, 'Y', 'N'), 'N') as COL_B
     , decode(b.ITEM_COL, 'COL_C', nvl2(b.ITEM_COL, 'Y', 'N'), 'N') as COL_C
     , decode(b.ITEM_COL, 'COL_D', nvl2(b.ITEM_COL, 'Y', 'N'), 'N') as COL_D
     , decode(b.ITEM_COL, 'COL_E', nvl2(b.ITEM_COL, 'Y', 'N'), 'N') as COL_E
     , decode(b.ITEM_COL, 'COL_F', nvl2(b.ITEM_COL, 'Y', 'N'), 'N') as COL_F
     ....
  from ALL_TAB_NAME a 
     , ITEM_LIST b
 where a.TABEL_NAME = 'TEST_TABLE'
   and a.COLUMN_NAME(+) = b.ITEM_COL헌줄로 나오게 하는데, column이 많아서...

decode를 않쓰고 할 수 있는 방법이 있을까요?

부탁드립니다