1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | WITH t AS ( SELECT 1 id, '안녕하세요.!' v FROM dual UNION ALL SELECT 2, '저는 20살 입니다.' FROM dual UNION ALL SELECT 3, 'hi 만나서반가워 나는 20살이야!' FROM dual UNION ALL SELECT 4, 'ㅋㅋㅋ' FROM dual UNION ALL SELECT 5, 'ㅠㅠ' FROM dual UNION ALL SELECT 6, '★○' FROM dual ) SELECT id, v , REGEXP_COUNT(v, '[가-힣ㄱ-ㅎㅏ-ㅣ]' ) 한글 , REGEXP_COUNT(v, '[[:lower:][:upper:]]' ) 영어 , REGEXP_COUNT(v, '[[:digit:]]' ) 숫자 , REGEXP_COUNT(v, '[[:punct:]]' ) 기호 , REGEXP_COUNT(v, '[[:space:]]' ) 공백 FROM t ; |