oracle 递归查询
SELECT
*
FROM
FD_PERMISSION
WHERE
STATUS = 1
START WITH ID = 1 CONNECT BY pid = PRIOR ID -- 递归查询子节点
ORDER BY
PERMISSION_LEVEL,
PID,
CRAETE_TIME;