T100拉取菜单目录

T100拉取菜单目录

select gzwe001 上阶目录编号,gzwe002 目录编号,gzwe004 节点型态,
case
when gzwe004=0 THEN (select gzwel003 from gzwel_t where gzwelent=gzweent and gzwel001=gzwe002 and gzwel002=‘zh_CN’)
when gzwe004=1 then (select gzzal003 from gzzal_t where gzzal001=gzwe002 and gzzal002=‘zh_CN’)
end as 菜单名称,
level as 层级,
sys_connect_by_path(gzwe002,’–>’) xh,lpad(’-’, 3* (level - 1), ‘-’)||gzwe002
from gzwe_t1
start with gzwe001=‘0’
connect by prior gzwe002 = gzwe001