oracle : 표현식(Regular Expression) 문자 자르기 > REGEXP_SUBSTR()

SELECT REGEXP_SUBSTR(‘첫번째_두번째_세번째’,'[^_]+’,1,1) FROM DUAL;

SELECT REGEXP_SUBSTR(‘첫번째_두번째_세번째’,'[^_]+’,1,2) FROM DUAL;

SELECT REGEXP_SUBSTR(‘첫번째_두번째_세번째’,'[^_]+’,1,3) FROM DUAL;