Oracle 按一行里某个字段里的值分割成多行进行展示

with t as (
select '111,222,333' col from dual
union all
select '444,555,666' col from dual
)
select regexp_substr(col, '[^,]+', 1, level) AS SUBJECT_IDS
from t
connect by level <= regexp_count(col, '[^,]+')
and col = prior col
and prior dbms_random.value > 0