oracle字符串拆分？

oracle 中可以用connect by把字符串按都好分割：比如定義字符串：pv_no_list :='23,34,45,56';SELECT DISTINCT REGEXP_SUBSTR (pv_no_list,'[^,]+',1,LEVEL) as "token"FROM DUALCONNECT BY REGEXP_SUBSTR (pv_no_list,'[^,]+',1,LEVEL) IS NOT NULLorder by 1返回結(jié)果：TOKEN23344556