WITH M_DATA
AS
(
SELECT ' ' AS A
FROM DUAL
UNION ALL
SELECT '가나다라 AFSAD' AS A
FROM DUAL
UNION ALL
SELECT 'AFSAD' AS A
FROM DUAL
)
SELECT A
FROM M_DATA
by 우리집아찌
[2018.04.02 18:03:23]
WITH M_DATA AS (
SELECT ' ' AS A
FROM DUAL
UNION ALL
SELECT '가나다라 AFSAD' AS A
FROM DUAL
UNION ALL
SELECT 'AFSAD가' AS A
FROM DUAL
)
SELECT A
FROM M_DATA
WHERE REGEXP_LIKE (A,'[ㄱ-힝]')
by 우리집아찌
[2018.04.02 18:15:53]
ㅎ -> ㄱ 으로 수정했어요.. ㅜㅜ
댓글등록
SQL문을 포맷에 맞게(깔끔하게) 등록하려면 code() 버튼을 클릭하여 작성 하시면 됩니다.