insert into role values (1,0,'guest','默认')
insert into role values (2,1,'dept','普通司局')
insert into role values (3,2,'dept','管理员')
select * from operation
insert into operation values(1,'登陆','')
insert into operation values(2,'浏览','')
insert into operation values(3,'新建','');
insert into operation values(4,'提交','');
insert into operation values(5,'发布','');
insert into operation values(6,'删除','');
insert into roleoperation values(1,1)
insert into roleoperation values(1,2)
insert into roleoperation values(2,3);
insert into roleoperation values(2,4);
insert into roleoperation values(3,5);
insert into roleoperation values(3,6);
select * from roleoperation
select r.roleid,r.proleid,r.name,rp.operationid,o.name from role r
join roleoperation rp on r.roleid = rp.roleid
join operation o on rp.operationid = o.operationid
select r.roleid,o.name from(select * from role start with roleid=1 connect by prior proleid = roleid) r
join roleoperation rp on r.roleid = rp.roleid
join operation o on rp.operationid = o.operationid
select * from role start with roleid=3 connect by prior proleid = roleid