字符串根据逗号分隔,行转列
字符串:'202109221642228171,202111101052134271,202204011510215937'
Select REGEXP_SUBSTR(
'202109221642228171,202111101052134271,202204011510215937' ,'[^,]+', 1, level) a
FROM DUAL
CONNECT BY level <= LENGTH(
'202109221642228171,202111101052134271,202204011510215937') - LENGTH(REGEXP_REPLACE(
'202109221642228171,202111101052134271,202204011510215937', ',', '')) + 1
转换结果: