SELECT REGEXP_SUBSTR('first field, second field , third field', '[^,]+', 1, level) AS split_data
FROM dual
CONNECT BY REGEXP_SUBSTR('first field, second field , third field', '[^,]+', 1, level) IS NOT NULL
AND PRIOR dbms_random.value IS NOT NULL
AND PRIOR 'first field, second field , third field' = 'first field, second field , third field';
sql 拆分 用逗号隔开的Id 返回一串用逗号隔开的Name
2024-06-12 13:20:02 10 阅读