今天组长给了我一张菜单表app_menu,要把里面的数据内容按照菜单进行调整,并且要筛选出一些系统里已经有的父菜单,我在网上查找资料后是这么写的:
select parentsid,
menuid,
(case
when menulevel = 1 then
'*' || menuname
when menulevel = 2 then
'*-----' || menuname
when menulevel = 3 then
'*-----*-----' || menuname
when menulevel = 4 then
'*-----*-----*------' || menuname
else
menuname
end) as menuname,
menulevel
from app_menu
start with parentsid is null
connect by prior menuid = parentsid