[Oracle] 중복기간 체크

중복기간 체크

SELECT CASE WHEN EXISTS (
       SELECT 1
         FROM CHECK_TABLE
        WHERE KEY0 = 'KEY0'
          AND KEY1 = 'KEY1'
          
          AND STA_YMD <> '시작일'
          AND STA_YMD <= '종료일'
          AND END_YMD >= '시작일'
       ) THEN 'Y' ELSE 'N' END DUP_YN
  FROM DUAL