SQL> select deptno,wm_concat(ename) bb from emp group by deptno; DEPTNO BB
---------- --------------------------------------------------
10 CLARK,KING,MILLER
20 SMITH,FORD,ADAMS,SCOTT,JONES
30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD
---------- --------------------------------------------------
10 CLARK,KING,MILLER
20 SMITH,FORD,ADAMS,SCOTT,JONES
30 ALLEN,BLAKE,MARTIN,TURNER,JAMES,WARD
解决方案 »
- Oracle database 9i/10g/11g编程艺术中,外键未加索引导致死锁的问题
- 关于Number的一些问题,希望各位高手帮忙看下
- 一个过程中多个游标问题
- 重装oracle9i后 如何把原来的数据库恢复呢??
- 请问一个关于number类型的问题!!!很奇怪
- 如何增量导出数据?
- alter tablespace system begin backup; 问什么提示无效字符?
- 在create database 时如何判断指定数据库名是否已经存在?
- 查询记录时怎么给记录加锁???????
- PLSQL执行脚本时怎么去除重复的数据
- 关于oracle10g透明网关连接sql server2005问题
- owi-读书笔记分享
(select 3 A, 2 B FROM DUAL UNION ALL SELECT 3 A, 4 B FROM DUAL),
T2 AS
(select 3 C, 6 D FROM DUAL UNION ALL select 7 C, 8 D FROM DUAL)
SELECT C, D, MAX(F)F
FROM (SELECT T2.C, T2.D, TO_CHAR(wm_concat(T1.B) OVER(ORDER BY T1.B)) F
FROM T1, T2
WHERE T1.A = T2.C)
GROUP BY C, D;