ORACLE树查询 start with ... connect by prior...
select * from t_menu t start with t.pid is null connect by prior t.id = t.pid order SIBLINGS by t.levelno;
t_menu: id ,pid(父菜单id),levelno(菜单显示级别);
语法:START WITH condition CONNECT BY NOCYCLE c...
原创
2012-12-13 17:16:03 ·
175 阅读 ·
0 评论