select LPAD(‘-----‘,t.menu_level)||t.obj_id,t.*,rowid from imes10dba.tb_adm_menu t
start with t.parent_menu_id = ‘90000‘
connect by prior t.menu_id = t.parent_menu_id;
oracle 树查询
原文：http://www.cnblogs.com/hqyj/p/6674930.html
