How Oracle splits a field's content into multiple lines of display

Example:

Select Regexp_substr (' 1,2,3,4,5 ', ' [^,]+ ', 1, level)
From dual
Connect by Level <= Regexp_count (' 1,2,3,4,5 ', ' [^,]+ ')

Interpretation:

The REGEXP_SUBSTR function is formatted as follows:

function Regexp_substr (String, pattern, position, occurrence, modifier)

__SRCSTR: A string that requires regular processing

__pattern: Regular expression for matching

__position: Starting position, starting with the first character of the regular expression match (default = 1)

__occurrence: Identifies the first few matching groups, which defaults to 1

__modifier: The pattern (' I ' is not case-sensitive for retrieval; ' C ' is case-sensitive for retrieval. The default is ' C '. ）

How Oracle splits a field's content into multiple lines of display