oracle迭代查询

oracle迭代查询

select id as parent_id,  sys_connect_by_path(id,'/') as child_ids from menu
start with id=1
connect by parent = prior id;

结果实例:  

CHILD_IDS
--------------------------------------------------------------------------------
/1
/1/6
/1/6/21
/1/6/21/38
/1/6/22
/1/6/22/39
/1/7
/1/7/23
/1/7/23/40
/1/7/24
/1/7/24/41