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
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,結果是正確的，可是出現了一個問題，STU_NAMES字段顯示(HUGECLOB)，只有點開后面的省略號才能看到字符串值，求解答
FROM (SELECT CI_ID,STU_NAME FROM PM_CI,PM_STU
WHERE INSTR(STU_IDS,STU_ID)<>0) GROUP BY CI_ID,結果是正確的，可是出現了一個問題，STU_NAMES字段顯示(HUGECLOB)，只有點開后面的省略號才能看到字符串值，求解答
最贊回答 / 慕的地2439609
把STU_NAMES用to_char轉一下，to_char(WM_CONCAT(STU_NAME)?)。應該是oracle高版本得到的WM_CONCAT結果默認是CLOB類型，用to_char轉一下就能看到值了
2018-06-01
最贊回答 / qq_星逝風起_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
--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
哇塞，在找關于趙強老師今晚在課堂上提出來的關于Oracle表自連接的缺點及解決方法時，碰巧就找到趙強老師本人解答的視頻了。厲害厲害，講的依舊清晰明了！明白了。贊！
2018-04-20