17,086
社区成员
发帖
与我相关
我的任务
分享
select TO_CHAR(p.DEAL_SQNO),
TO_CHAR(p.DEAL_SQNO),
TO_CHAR(p.LINK_DEAL_SQNO),
P.*
from DEAL P
start with TO_CHAR(LINK_DEAL_SQNO) IS NULL
CONNECT BY (PRIOR
TO_CHAR(LINK_DEAL_SQNO) = TO_CHAR(DEAL_SQNO))
select connect_by_root TO_CHAR(p.DEAL_SQNO) root ,TO_CHAR(DEAL_SQNO),TO_CHAR(LINK_DEAL_SQNO) LINK_NO, p.*
from deal_spot P
where cus_number='580' and TO_CHAR(LINK_DEAL_SQNO) IS NOT NULL
start with TO_CHAR(LINK_DEAL_SQNO) IS NULL
CONNECT BY (PRIOR TO_CHAR(DEAL_SQNO) =
TO_CHAR(LINK_DEAL_SQNO) )
好像这样是OK的? 但是感觉性能会惨不忍睹啊... 继续求大腿帮忙看看.