select ci_id,wm_concat(stu_name) stu_name
from pn_ci a,pm_stu b
where instr(stu_ids,stu_id)>0
group by ci_id;
from pn_ci a,pm_stu b
where instr(stu_ids,stu_id)>0
group by ci_id;
2018-06-28
SELECT CI_ID,TO_CHAR(WM_CONCAT(STU_NAME)) STU_NAMES
FROM (SELECT * FROM PM_CI,PM_STU
WHERE INSTR(STU_IDS,STU_ID)<>0)
GROUP BY CI_ID
FROM (SELECT * FROM PM_CI,PM_STU
WHERE INSTR(STU_IDS,STU_ID)<>0)
GROUP BY CI_ID
2018-06-01
SELECT CI_ID,WM_CONCAT(STU_NAME) STU_NAMES
FROM (SELECT CI_ID,STU_NAME FROM PM_CI,PM_STU
WHERE INSTR(STU_IDS,STU_ID)<>0) GROUP BY CI_ID,結(jié)果是正確的，可是出現(xiàn)了一個(gè)問題，STU_NAMES字段顯示(HUGECLOB)，只有點(diǎn)開后面的省略號(hào)才能看到字符串值，求解答
FROM (SELECT CI_ID,STU_NAME FROM PM_CI,PM_STU
WHERE INSTR(STU_IDS,STU_ID)<>0) GROUP BY CI_ID,結(jié)果是正確的，可是出現(xiàn)了一個(gè)問題，STU_NAMES字段顯示(HUGECLOB)，只有點(diǎn)開后面的省略號(hào)才能看到字符串值，求解答
2018-06-01
最贊回答 / 慕的地2439609
把STU_NAMES用to_char轉(zhuǎn)一下，to_char(WM_CONCAT(STU_NAME)?)。應(yīng)該是oracle高版本得到的WM_CONCAT結(jié)果默認(rèn)是CLOB類型，用to_char轉(zhuǎn)一下就能看到值了
2018-06-01
最贊回答 / qq_星逝風(fēng)起_0
select ci_id,wm_concat(stu_name) stu_name ? ?from pn_ci a,pm_stu bwhere instr(stu_ids,stu_id)>0?group by ci_id;
2018-05-31
最新回答 / 風(fēng)鈴在想什么
不用建表，只要你用scott用戶登陸到sqlplus 后就能select出來emp這個(gè)表，這張表里面的數(shù)據(jù)也是有的，應(yīng)該是Oracle內(nèi)置的一個(gè)表
2018-05-29
--oracle 右連接
Select d.deptno,d.dname,Count(e.empno) from emp e,dept d
Where e.deptno(+) = d.deptno
Group By d.deptno,d.dname
--mysql 右連接
Select d.deptno,d.dname,Count(e.empno)
from emp e Right Join dept d On e.deptno= d.deptno
Group By d.deptno,d.dname
Select d.deptno,d.dname,Count(e.empno) from emp e,dept d
Where e.deptno(+) = d.deptno
Group By d.deptno,d.dname
--mysql 右連接
Select d.deptno,d.dname,Count(e.empno)
from emp e Right Join dept d On e.deptno= d.deptno
Group By d.deptno,d.dname
2018-05-27
select deptno,listagg(ename,',') within group (order by deptno) enameList from emp group by deptno;
2018-05-16
哇塞，在找關(guān)于趙強(qiáng)老師今晚在課堂上提出來的關(guān)于Oracle表自連接的缺點(diǎn)及解決方法時(shí)，碰巧就找到趙強(qiáng)老師本人解答的視頻了。厲害厲害，講的依舊清晰明了！明白了。贊！
2018-04-20