示例1:自定义层级菜单

select level as level_value 
       , priv_name as label_value 
       , "ATTR1" as target_value
       , null as is_current 
       , "ATTR2" as image_value 
       , null as image_attr_value 
       , null as image_alt_value 
from "SYS_PRIVS" 
where priv_type = 2 
start with priv_pid is null 
connect by prior priv_id = priv_pid


  • No labels