oracle如何拆分带逗号的内容答:SELECT '15,13,12,15,16,41,13,16' AS ID FROM DUAL) SELECT ID,COUNT(ID) FROM (SELECT REGEXP_SUBSTR(ID, '[^,]+', 1, ROWNUM) AS ID FROM TMP_TAB CONNECT BY ROWNUM <= LENGTH(ID) - LENGTH(REPLACE(ID, ',', '')) + 1) GROUP BY ID ...
Oracle中某一表单中的字段里的存放的值为逗号隔开另一表单字段中的多个...答:create table stuu(code char(4), course_id varchar2(50),cdate date); --创建表 --插入测试数据 insert into stuu(code,course_id,cdate) values('1','1001',sysdate);insert into stuu(code,course_id,cdate) values('2','1001,1002',sysdate);insert into stuu(code,course_id,cdat...