摘要:
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 阅读全文