Oracle uses regular expressions to split a string

General character Splitting method

SelectREGEXP_SUBSTR (Str,'[^,]+',1, Level)STR   from(Select '11,12,13,14,15,16' Str  fromdual) CONNECT by  Level <=Regexp_count (Str,'[^,]+');

To split with a special number character:

line break, carriage return, TAB tab CHR in Oracle text (9) newline character chr (Ten) Carriage return Chr ( -Break Example of newline characters: with Data_change as(SelectRegexp_substr (str,'[^'|| ChrTen) ||']+',1, Level) STR from(Select 'ABCDE'Str fromdual) CONNECT by Level<= Regexp_count (str,'[^'|| ChrTen) ||']+'))SelectC.str fromData_change C

Oracle uses regular expressions to split a string