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中某一表单中的字段里的存放的值为逗号隔开另一表单字段中的多个...答: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,cdate) values('3','1001,1002,1003',sysdate);create table cours(id char(4),cname varchar2(10));-...
oracle数据库一个表字段中存了id,并以逗号分隔,id对应的详细信息在另...答:FROM leader t INNER JOIN leader_name t1 ON INSTR( CONCAT(',', t.aid, ','), CONCAT(',', t1.bid, ',') ) > 0 GROUP BY t1.aid ;试试,思路就是根据字符串截取,匹配id,然后group by,行转列。防止那种1匹配到10,就按照前后加逗号的方式 ...
Oracle中怎样将字段字符串以逗号为界截取,并将得到的子串通过函数解释后...答:select replace(replace(replace('001,002,003','001','a'),'002','b'),'003','c') from table公司网络受限,没法传图了。。。只能发一下了,测试的数据 select replace(replace(replace('001,002,003','001','a'),'002','b'),'003','c') from dualREPLACE(REPLACE(REPLACE('001,...