SELECT rd.menu_id,lpad(name,length(name)+(LEVEL*8)-1,'.') FROM sys_menu rd
CONNECT BY PRIOR rd.menu_id=rd.parent_id
START WITH rd.parent_id =0
SELECT rd.menu_id,lpad(name,length(name)+(LEVEL*8)-1,'.') FROM sys_menu rd
CONNECT BY PRIOR rd.menu_id=rd.parent_id
START WITH rd.parent_id =0