Oracle Split string REGEXP_SUBSTR usage

Splits all specified characters in a string and then into multiple lines
Parameter description,
Parameter 1: string to be split
Parameter 2: Regular expression
Parameter 3: Starting position, starting with the first character of the regular expression match (default is 1)
Parameter 4: Identifies the first matching group, which defaults to 1
Parameter 5: The pattern (' I ' is not case-sensitive for retrieval; ' C ' is case-sensitive for retrieval. The default is ' C '. ）

--sample delimiter '; ', split into columnsSelectREGEXP_SUBSTR ('a;b;c;','[^;] +',1, RowNum,'C') asRegexp_strs fromDual Connect byRowNum<=Length (Regexp_replace ('a;b;c;','[^;]',NULL));

Results:

Refer to 1:oracle practical SQL to split a comma-separated string into multiple columns

Reference 2:77,864,060

Oracle Split string REGEXP_SUBSTR usage