现在有两个表
表1 : PG_BSRK
表2 : PG_BSXX
表1
Uid Content
1 A01
2 A02
2 A03
3 A08
1 A07
表2
Uuid
1
2
3
当我想实现这样的结果时
1 A01#A07
2 A02#A03
3 A08我用这样的写法select Substr(Sys_Connect_By_Path(rkpzh, '#'), 2) as id
From (Select Rownum Rid, Rownum + 1 Next_Rid, rkpzh
From PG_BSRK
where bsxxbh = 1/2/3)
Where Rid = (Select Count(*) From PG_BSRK where bsxxbh = 1/2/3)
Start With Rid = 1
Connect By Prior Next_Rid = Rid单条都行 可是我换成关联下表2的UUID(里面也只有123)得到的结果就不对....请高手指教一二 3QQQQ!!!!
写法如下:
select
(select Substr(Sys_Connect_By_Path(rkpzh, '#'), 2) as id
From (Select Rownum Rid, Rownum + 1 Next_Rid, rkpzh
From PG_BSRK
where bsxxbh = a.bsxxbh)
Where Rid = (Select Count(*) From PG_BSRK where bsxxbh = a.bsxxbh)
Start With Rid = 1
Connect By Prior Next_Rid = Rid)
from PG_BSXX a
表1 : PG_BSRK
表2 : PG_BSXX
表1
Uid Content
1 A01
2 A02
2 A03
3 A08
1 A07
表2
Uuid
1
2
3
当我想实现这样的结果时
1 A01#A07
2 A02#A03
3 A08我用这样的写法select Substr(Sys_Connect_By_Path(rkpzh, '#'), 2) as id
From (Select Rownum Rid, Rownum + 1 Next_Rid, rkpzh
From PG_BSRK
where bsxxbh = 1/2/3)
Where Rid = (Select Count(*) From PG_BSRK where bsxxbh = 1/2/3)
Start With Rid = 1
Connect By Prior Next_Rid = Rid单条都行 可是我换成关联下表2的UUID(里面也只有123)得到的结果就不对....请高手指教一二 3QQQQ!!!!
写法如下:
select
(select Substr(Sys_Connect_By_Path(rkpzh, '#'), 2) as id
From (Select Rownum Rid, Rownum + 1 Next_Rid, rkpzh
From PG_BSRK
where bsxxbh = a.bsxxbh)
Where Rid = (Select Count(*) From PG_BSRK where bsxxbh = a.bsxxbh)
Start With Rid = 1
Connect By Prior Next_Rid = Rid)
from PG_BSXX a
Uuid 就是 a.bsxxbh