[파란형-Tipoazul] oracle REGEXP_SUBSTR 예제

REGEXP_SUBSTR 예제 예제) 1 REM Extracting letter and number sequences from a string 문자열에서 문자 및 숫자 시퀀스 추출 with strings as ( select 'ABC123' str from dual union all select 'A1B2C3' str from dual union all select '123ABC' str from dual union all select '1A2B3C' str from dual ) select regexp_substr(str, '[0-9]'), regexp_substr(str, '[0-9].*'), regexp_substr(str, '[A-Z][0-9]') from strings 1 123 C1 1 1B2.....