문자만 자르기(정규식함수 사용-REGEXP_SUBSTR)

WITH T ( P_CODE , P_NM ) AS (
SELECT 'P0001', '사과(SP)' FROM DUAL UNION ALL
SELECT 'P0002', '파인애플 1200*900' FROM DUAL UNION ALL
SELECT 'P0003', '바나나 CL-100' FROM DUAL UNION ALL
SELECT 'P0004', '오렌지ECE' FROM DUAL UNION ALL
SELECT 'P0005', '참외 ZG' FROM DUAL
)select * from t;

sol)

WITH T ( P_CODE , P_NM ) AS (
SELECT 'P0001', '사과(SP)' FROM DUAL UNION ALL
SELECT 'P0002', '파인애플 1200*900' FROM DUAL UNION ALL
SELECT 'P0003', '바나나 CL-100' FROM DUAL UNION ALL
SELECT 'P0004', '오렌지ECE' FROM DUAL UNION ALL
SELECT 'P0005', '참외 ZG' FROM DUAL
)
SELECT P_CODE , p_nm,REGEXP_SUBSTR ( P_NM ,'[ㄱ-힝]+') P_NM_RESULT FROM T;

//정규식으로 문자열을 Substr 하는함수

//문장에서 문자([ㄱ-힝])까지의 문자가 하나 이상(+)있는 것만 짤라내는 것이다.