WITH t AS ( SELECT 'id94' id FROM dual UNION ALL SELECT '가나다라' FROM dual UNION ALL SELECT '가나다라(aaa)' FROM dual UNION ALL SELECT 'aaa_가나다라' FROM dual UNION ALL SELECT 'ㅁㅁㅁ' FROM dual UNION ALL SELECT 'aaa123' FROM dual UNION ALL SELECT '1234' FROM dual UNION ALL SELECT ' 1 2 3 4 ' FROM dual UNION ALL SELECT ' 1 ㄱ 2 ㄴ 3 ㄷ 4 ' FROM dual UNION ALL SELECT '궵런디ㅏㅓㄹ' FROM dual UNION ALL SELECT '꾸에~~붹뷇뷁' FROM dual UNION ALL SELECT 'adDS' FROM dual ) SELECT * FROM t WHERE NOT REGEXP_LIKE(id, '[가-힣]') OR REGEXP_LIKE(id, '[:alnum:]') OR REGEXP_LIKE(id, '[:punct:]') ;
이런식으로 했는데 안걸리는게 몇개가 밑에서 2번째 3번째는 걸리지 않습니다.
혹시 방법이 있나요??
여기서는 '가나다라' 이것만 안나오게 하는 방법이 없을까요?