select ... from <TableName>
where <Conditional-1>
start with <Conditional-2>
connect by <Conditional-3>;
//<Conditional-1>：过滤条件，用于对返回的所有记录进行过滤。
//<Conditional-2>：查询结果重起始根结点的限定条件。
//<Conditional-3>：连接条件
//如果connect by prior中的prior被省略，则查询将不进行深层递归。select t.* from s_menu t start with t.id='510' connect by prior t.fid = t.idselect t.* from s_menu t start with t.id='510' connect by prior t.fid = t.idselect t.* from s_menu t start with t.id='001' connect by prior t.id = t.fid select t.* from s_menu t start with t.id='001' connect by prior t.id = t.fidselect t.id,t.name,fid,substr(sys_connect_by_path(NAME,'->'),3) menu_path
from s_menu t start with t.name = '系统功能' connect by prior t.id = t.fid order by t.idselect t.id,lpad('|-',(level-1)*4,'|-')||lpad('『',2)||t.name||rpad('』',2) as newname
from s_menu t connect by prior t.id=t.fid start with t.id='-1'向上递归和向下递归的关键就是最后一个条件，父ID等于ID则向上递归，反之向下递归。参考：http://www.cnblogs.com/wanghonghu/archive/2012/08/31/2665945.html
免责声明：本站发布的内容（图片、视频和文字）以原创、转载和分享为主，文章观点不代表本网站立场，如果涉及侵权请联系站长邮箱：is@yisu.com进行举报，并提供相关证据，一经查实，将立刻删除涉嫌侵权内容。
