create table jsdld.wggl_workgroup as select * from zzjxkh.wggl_workgroup; 从一张表里读数据;
select * from wggl_depart d START WITH PID = 8 CONNECT BY PRIOR ID = PID
union all
select * from wggl_depart d where d.id=8 查询金水区的机构
select * from xtgl_superusers s ,(select id from wggl_depart START WITH PID = 8 CONNECT BY PRIOR ID = PID union select id from wggl_depart where id=8)a
where a.id=s.userdcode; 查询金水区用户
192.168.1.36 ZZJXKH