Oracle recursive query

1 SelectA.accountcodeid, A.accountcode, A.accountcodename,2Sys_connect_by_path (A.accountcodename,'\') asFullName, A.parentcodeid, Level3    fromFm_accountcode a4  whereA.accountcodeid>= 100005Start withA.parentcodeid is NULL6Connect byPrior A.accountcodeid=A.parentcodeid;7 8 SelectA.accountcodeid, A.accountcode, A.accountcodename,9Sys_connect_by_path (A.accountcodename,'\') asFullName,Ten A.parentcodeid One    fromFm_accountcode a A  whereA.accountcodeid> 10000 -     andConnect_by_isleaf= 1 -Start withA.parentcodeid is NULL theConnect byPrior A.accountcodeid=A.parentcodeid;

Recursive queries in Oracle are useful for tree-structured data.

The difference: On, all data, including structure, below, all stub points, including structure, see Oracle Document 11g.

Oracle recursive query