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일지에 대해 체크 후 반환 Programing/Database 2020.10.22