Oracle 存储过程面试题
答案:2 悬赏:80 手机版
解决时间 2021-03-05 22:33
- 提问者网友：心如荒岛囚我终老
- 2021-03-05 16:24
Oracle 存储过程面试题
最佳答案
- 五星知识达人网友：撞了怀
- 2021-03-05 16:58
根据你现有的内容，做个完全同步的
merge into frp.t17_organ d
using frp.t40_organ s
on (s.organno=d.organno)
when matched then update set d.organname=s.organname,.....
when not matched then insert values (s.organno.........)
完整题目可以发我私信
merge into frp.t17_organ d
using frp.t40_organ s
on (s.organno=d.organno)
when matched then update set d.organname=s.organname,.....
when not matched then insert values (s.organno.........)
完整题目可以发我私信
全部回答
- 1楼网友：封刀令
- 2021-03-05 17:19
提供参考
DECLARE
BEGIN
merge INTO t17_organ t1
USING t40_organ t2
ON t1.organno=t2.organno
WHEN matched THEN
UPDATE
SET t1.organname=t2.organname,
t1.organlevel =t2.organlevel,
t1.uporgankey =t2.uporgankey,
t1.flag =t2.flag ;
COMMIT;
END;
/
DECLARE
BEGIN
merge INTO t17_organ t1
USING t40_organ t2
ON t1.organno=t2.organno
WHEN matched THEN
UPDATE
SET t1.organname=t2.organname,
t1.organlevel =t2.organlevel,
t1.uporgankey =t2.uporgankey,
t1.flag =t2.flag ;
COMMIT;
END;
/
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！
大家都在看
推荐资讯