Oracle 遞迴查詢

標籤：

 1 select a.accountcodeid, a.accountcode, a.accountcodename, 2        SYS_CONNECT_BY_PATH(a.accountcodename, ‘\‘) as fullname, a.parentcodeid, level 3   from fm_accountcode a 4  where a.accountcodeid >= 10000 5  start with a.parentcodeid is null 6 connect by prior a.accountcodeid = a.parentcodeid; 7  8 select a.accountcodeid, a.accountcode, a.accountcodename, 9        SYS_CONNECT_BY_PATH(a.accountcodename, ‘\‘) as fullname,10        a.parentcodeid11   from fm_accountcode a12  where a.accountcodeid > 1000013    and connect_by_isleaf = 114  start with a.parentcodeid is null15 connect by prior a.accountcodeid = a.parentcodeid;

oracle 中遞迴查詢，對樹型結構資料相當有用。

二者區別：上，所有資料，包含結構；下，所有末節點，包含結構，具體參見Oracle Document 11g。

Oracle 遞迴查詢