SELECT level, id, SYS_CONNECT_BY_PATH(o, '.') pa
FROM (
SELECT t.*,row_number()over(PARTITION BY pid ORDER BY id)o FROM t
)t
START WITH id ='1'
CONNECT BY pid = prior id
FROM (
SELECT t.*,row_number()over(PARTITION BY pid ORDER BY id)o FROM t
)t
START WITH id ='1'
CONNECT BY pid = prior id
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货