Oracle setting menu full path
1. First set the full_name (full path) update S_DEPARTMENT t set t.full_name ='XX Group 'where fid='-1' of the first-level menu 2. Set the full_nameupdate of the secondary menu (select a. Depended name dd,b.full_name cc from (select * from S_DEPARTMENT where dep_level ='2') a -- get second-level menu (select * from S_DEPARTMENT where dep_level ='1') b-- get first-level menu where a.fid = b.id) set full_name = cc | |'/'| | dep_name
