이런식으로 될까요?

with t as (
select 'new_mem' MEM, 'N' CHK from dual union all
select 'old_mem' , 'Y' from dual
)
select max(decode(mem,'new_mem',chk)) new_mem, max(decode(mem,'old_mem',chk)) old_mem from t

SELECT MIN(DECODE(mem, 'new_mem', chk)) new_mem
     , MIN(DECODE(mem, 'old_mem', chk)) old_mem
  FROM t
;

SELECT *
  FROM t
 PIVOT (MIN(chk) FOR mem IN ('new_mem' new_mem, 'old_mem' old_mem))
;