Oracle recursive query and Oracle recursive query

Oracle recursive query and Oracle recursive query

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

Recursive queries in oracle are very useful for tree structure data.

Differences between the two: above, all data, including the structure; below, all the last nodes, including the structure, see Oracle Document 11g for details.