同时执行多条SQL语句

转载于 2019-08-08 04:21:14 发布 · 8.8k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/qq1040991197/archive/2013/03/14/2959636.html

文章标签：

#数据库 #python #java

本文介绍了一种通过PL/SQL脚本更新数据库角色权限的方法，具体包括删除旧的权限分配、为特定角色添加新的操作权限，涉及到的角色ID为2，新增的操作代码包括300090010、300090020和300090050。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

BEGIN
  DELETE FROM SYSROLEOPENR WHERE ROLEID = 2;
  INSERT INTO SYSROLEOPENR
(PKID, ROLEID, OPERID)
SELECT SYSROLEOPENR_PKID_SEQ.NEXTVAL, '2' ROLEID, OPERID
   FROM SYSMODULEOPER
   WHERE OPERCODE = '300090010';
  INSERT INTO SYSROLEOPENR
(PKID, ROLEID, OPERID)
SELECT SYSROLEOPENR_PKID_SEQ.NEXTVAL, '2' ROLEID, OPERID
   FROM SYSMODULEOPER
   WHERE OPERCODE = '300090020';
  INSERT INTO SYSROLEOPENR
(PKID, ROLEID, OPERID)
SELECT SYSROLEOPENR_PKID_SEQ.NEXTVAL, '2' ROLEID, OPERID
   FROM SYSMODULEOPER
   WHERE OPERCODE = '300090050';