比如定义字符串: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返回结果:TOKEN23344556
博客园 © 2004-2025 浙公网安备 33010602011771号 浙ICP备2021040463号-3