Oracle 输出树形结构
树形结构,根 select connect_by_root(cat.parentid) root,cat.id,cat.parentid,cat.name,cat.code,SYS_CONNECT_BY_PATH(name,'/') path from V cat start with cat.parentid in (37558) connect by prior cat.id= cat.parentid
树形结构,一级子目录 select connect_by_root(cat.id) root,cat.id,cat.parentid,cat.name,cat.code,SYS_CONNECT_BY_PATH(name,'/') path from A cat start with cat.parentid in (select id from bto_c2.category_new where parentid = 37558) connect by prior cat.id= cat.parentid
注:
root :根
path : 路径