oracle 语句

//为全局用户分配某一权限
begin
for i in (select distinct user_id from cu_user_role) loop
insert into cu_user_role values (i.user_id,'211');
end loop;
end;
或者
begin
for i in (select user_id from cu_user) loop
insert into cu_user_role values (i.user_id,'211');
end loop;
end;

//为正处级用户分配某一权限
begin
for i in
(select user_id  from cu_user t where t.position_level='10') loop
insert into cu_user_role values(i.user_id,'212');
end loop;
end;

导出用户下的所有数据:
exp cums/itownet@jzzy_10.31.46.46 owner=cums file=cums.dmp log=cums.log buffer=1024000000

exp rams/itownet@jzzy_10.31.46.46 owner=rams file=rams.dmp log=rams.log buffer=1024000000

 

从一个表读取数据插入到另一个表中
insert into t_public_email_apply (org_code) select t2.orgid from cums.cu_dept t2

给用户分配查询，读写权限
grant select,insert,update  on cu_user_appertain to cums;

配置数据库连接(E:\oracle\network\ADMIN\tnsnames.ora)：
jzzy =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.31.46.46)(PORT = 1521))
    (CONNECT_DATA =
      (SERVICE_NAME = jzzy)
      (INSTANCE_NAME = jzzy)
    )
  )