内容以 , 分割,多列展示

SELECT REGEXP_SUBSTR(BHALL,'[^,]+',1,ROWNUM) BH FROM (SELECT ('1A000000002702758284,1A000000002702758285,1A000000002702758334') BHALL FROM DUAL) CONNECT BY ROWNUM <= LENGTH(BHALL) - LENGTH(REPLACE(BHALL,',','')) + 1 

结果: