oracle 树形表结构排序

oracle 树形表结构排序

select * from Table
 start with parentid is null connect by prior id=parentid
 order SIBLINGS by FUNCTIONORDER


 ID    NVARCHAR2    32
parentid    NVARCHAR2    32
FUNCTIONNAME    NVARCHAR2    50
FUNCTIONLEVEL    NUMBER    0
FUNCTIONURL    NVARCHAR2    100
ICONPATH    NVARCHAR2    2000
FUNCTIONORDER    NVARCHAR2    10