SQL SELECT 텍스트 조건식 반영

SELECT USER, (case when isyn = 'y' then '정상' ELSE '비정상' END) AS result

FROM (SELECT 'abcd' AS user, 'n' AS isyn

FROM dual) AS t;

YN 여부가 Y인지, N일지에 대해 체크 후 반환