他那个有点复杂,看不懂,先来简单点的 SQL> SELECT ename FROM emp ORDER BY ename; ENAME ---------- CLARK KING MILLER想输出为: ENAME ---------- CLARK, KING, MILLER 这个应该怎么写? 非常感谢
select substr(max(sys_connect_by_path(ename,',')),2) ename from (select a.*,row_number()over(order by ename) rn from emp )
start with rn=1 connect by rn-1=prior rn
select substr(max(sys_connect_by_path(ename,',')),2) ename from (select emp.*,row_number()over(order by ename) rn from emp ) start with rn=1 connect by rn-1=prior rn
http://topic.csdn.net/u/20080505/11/a0958b42-d938-465f-972a-0f61a2969c97.html?seed=491226048
用sys_connect_by_path,麻烦点
SQL> SELECT ename FROM emp ORDER BY ename; ENAME
----------
CLARK
KING
MILLER想输出为:
ENAME
----------
CLARK, KING, MILLER 这个应该怎么写? 非常感谢
from (select a.*,row_number()over(order by ename) rn from emp )
start with rn=1
connect by rn-1=prior rn
from (select emp.*,row_number()over(order by ename) rn from emp )
start with rn=1
connect by rn-1=prior rn