Oracle菜单类型递归查询Demo

数据库 , 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
SELECT
    level,
    f.id,
    f.parentfunctionid,
    rpad(' ', (level - 1) * 5)
    || f.functionname functionname,
    f.functionorder
FROM
    t_s_function f
START WITH
    f.id = '402889fb486e848101486e8de3d60005'
CONNECT BY
    f.parentfunctionid = PRIOR f.id
ORDER BY
    level,
    f.functionorder;