Sys_Connect_By_Path 在10G 第4版的问题
在10G 10.2.0.4 下查不出数据,但是在 10.2.0.1 中可以
语句如下
Select Sys_Connect_By_Path(ceseid, ',') as OutStr
From (Select Rownum Rid, Rownum + 1 Next_Rid, ceseid, enable
From (select * from PS_Corporate_structure where enable = 0))
Where Rid =
(Select Count(*)
From (select * from PS_Corporate_structure where enable = 0))
Start With Rid = 1
Connect By Prior Next_Rid = Rid
功能就是行转列,等同于
select wmsys.wm_concat(ceseid) from PS_Corporate_structure
想问数据库是不是要打什么补丁??