oracle查询树的通用查询语句

SELECT  t.menuid as id, t.menu_name as name, 
        t.s_m_menuid as pid,  LEVEL as treelevel, CONNECT_BY_ISLEAF as isleaf,
        t.left_url, t.middle_url, t.image_url, t.external_message_url,
        t.automenu, t.menu_sort, t.remark, t.tag,t.ismenu_tag
        FROM S_MENU t 
        start with t.s_m_menuid = '0'
        connect by  t.s_m_menuid =  prior  t.menuid

        ORDER SIBLINGS BY t.menu_sort

说明：1.在S_MENU表中0代表父节点，start with表示从那一层开始，后面跟表达式.

   2.prior表示返回所有符合这种条件的connect by操作结果.

   3.order siblings by 的意思就是在兄弟姐妹之间的排序.