MERGE 用法
来源:互联网 发布:测量员软件视频教程 编辑:程序博客网 时间:2024/05/02 04:19
MERGE INTO SYS_USER_POS PS
USING (SELECT U.USERID, M.ORG_ID, M.POS_ID
FROM SYS_USER U
INNER JOIN MID_SYS_USER_PMP_SYNC M ON U.ACCOUNT = M.ACCOUNT WHERE M.CHECK_STATUS = '0') INTEG
ON (PS.USERID = INTEG.USERID)
WHEN NOT MATCHED THEN
INSERT
(PS.USERPOSID, PS.POSID, PS.USERID, PS.ISPRIMARY, PS.ORGID, PS.ASSID)
VALUES
(UNIQUEIDUTIL_ID.NEXTVAL,
INTEG.POS_ID,
INTEG.USERID,
1,
INTEG.ORG_ID,
0)
WHEN MATCHED THEN
UPDATE SET PS.POSID = INTEG.POS_ID, PS.ORGID = INTEG.ORG_ID;
INSERT INTO SYS_BPM_USE_ROLE
(ID,
ROLEID,
ROLENAME,
USERID,
ACCOUNT,
FULLNAME,
ORGID,
ORGTYPE,
AREAID,
CATEGORYID,
CREATETIME,
BQ_ORGID)
SELECT UNIQUEIDUTIL_ID.NEXTVAL AS ID,
M.USERATTRID AS ROLEID,
M.USERATTRNAME AS ROLENAME,
N.USERID AS USERID,
SU.ACCOUNT AS ACCOUNT,
SU.FULLNAME AS FULLNAME,
N.ORGID AS ORGID,
M.ORGTYPE AS ORGTYPE,
M.AREAID AS AREAID,
M.CATEGORYID AS CATEGORYID,
V_IDATE AS CREATETIME,
(SELECT SO.ORG_ID
FROM SYS_ORG_BPM SO
WHERE SO.ORG_TYPE_X = V_IBQ
AND ROWNUM = 1
START WITH SO.ORG_ID = O.ORG_ID
CONNECT BY SO.ORG_ID = PRIOR SO.ORG_SUPID) AS BQ_ORGID
FROM MID_SYS_BPM_USE_ROLE M
LEFT JOIN (SELECT UR.ROLEID AS ROLEID,
UR.USERID AS USERID,
DECODE(URO.ORGID, NULL, UR.ORGID, URO.ORGID) ORGID
FROM SYS_USER_ROLE UR
LEFT JOIN SYS_USERROLE_ORG URO ON URO.USERROLEID =
UR.USERROLEID) N ON M.USERATTRID =
N.ROLEID
- merge用法
- MERGE用法
- merge用法
- merge用法
- MERGE 用法
- MERGE 用法
- merge用法
- oracle-merge用法详解
- oracle-merge用法详解
- oracle-merge用法详解
- oracle-merge用法详解
- oracle-merge用法详解
- oracle-merge用法详解
- oracle-merge用法详解
- 关于MERGE 的用法
- merge into用法
- SQL:merge 用法
- Oracle的MERGE用法
- map有关实例代码
- 网络编程API函数描写
- Android Studio系列教程六--Gradle多渠道打包
- IOS 根据汉字获取首字母
- Hessian矩阵
- MERGE 用法
- Minimum Path Sum
- metro应用简述
- Java多线程-线程的同步与锁
- 在HTML5中, web app 以及手机客户端中,设置页面图片等比例居中显示
- Linux--线程编程
- 软件的生命周期
- 关于mysql与emoji的坑
- 针对中科院汉语分词系统nlpir中的中文分词部分在java环境的部署(Linux和windows)(获取关键词)