摘要：SELECT REGEXP_SUBSTR('first field, second field , third field', '[^,]+', 1, rownum) FROM DUAL CONNECT BY ROWNUM <= LENGTH('first field, second field , 阅读全文

摘要：select * from qx_role where N_role_id in ( 1,2,3) 运行结果： select to_char(wm_concat(c_role_name)) from qx_role where N_role_id in ( SELECT REGEXP_SUBSTR 阅读全文