Oracle Update多表关联更新
来源:互联网 发布:书生软件打不开sep 编辑:程序博客网 时间:2024/05/20 09:48
项目中用到了Oracle Update多表关联更新,简单记录一下
写法一:
update TBL_COMPANY_USER card
set card.status = 9
where card.company_id =
(select company.ID
from TBL_COMPANY_INFO company
where company.CODE = '10001')
and card.cp_id =
(select cp.ID from TBL_CP_INFO cp where cp.CODE = '01')
and card.card_face_no = '10756415700'
写法二:
update TBL_COMPANY_USER card
set card.status = 2
where exists (select *
from TBL_COMPANY_INFO tcoi, TBL_CP_INFO tcpi
where card.company_id = tcoi.id
and card.cp_id = tcpi.id
and tcoi.code = '10001'
and tcpi.code = '01'
and card.card_face_no = '10756415700')
写法三:
UPDATE table_1 a
SET col_x1 = (SELECT b.col_y1, b.col_y2 FROM table_2 b WHERE b.col_n = a.col_m),
col_x2 = (SELECT b.col_y2 FROM table_2 b WHERE b.col_n = a.col_m)
WHERE EXISTS (SELECT * FROM table_2 b WHERE b.col_n = a.col_m)
或
UPDATE table_1 a
SET col_x1 = (SELECT b.col_y1, b.col_y2 FROM table_2 b WHERE b.col_n = a.col_m),
col_x2 = (SELECT b.col_y2 FROM table_2 b WHERE b.col_n = a.col_m)
WHERE a.col_m=(SELECT b.col_n FROM table_2 b WHERE b.col_n = a.col_m)
写法四:
UPDATE table_1 a
SET (col_x1, col_x2) = (SELECT b.col_y1, b.col_y2 FROM table_2 b WHERE b.col_n = a.col_m)
WHERE EXISTS (SELECT * FROM table_2 b WHERE b.col_n = a.col_m);
或
UPDATE table_1 a
SET (col_x1, col_x2) = (SELECT b.col_y1, b.col_y2 FROM table_2 b WHERE b.col_n = a.col_m)
WHERE a.col_m=(SELECT b.col_n FROM table_2 b WHERE b.col_n = a.col_m)
- oracle UPDATE 多表关联更新
- Oracle 多表关联更新update
- Oracle Update多表关联更新
- Oracle多表关联更新(update多表关联)
- Oracle多表关联更新(update多表关联)
- oracle update多表关联
- oracle update 多表关联
- oracle update多表关联
- oracle 多表关联 update
- ORACLE多表关联UPDATE
- Oracle update 两表及以上关联更新,出现多值情况,不是一对一更新
- 多表关联更新,UPDATE FROM用法
- SQL update 多表关联更新
- UPDATE与多表关联更新
- update left join 多表关联更新,
- SQL update 多表关联更新
- oracle 实现 关联两个表更新 update select
- oracle多表关联更新(update)/删除(delete)数据表的的写法
- Eclipse Maven配置
- 微信蓝牙设备开发--添加设备以及获取微信为设备生成的二维码
- HDU6038 & 2017 Multi-University Training Contest
- Android系统中UID
- angularjs路由配置$route以及案例展示
- Oracle Update多表关联更新
- VS安装远程调试步骤
- Unity 光照探针Light Probes
- javadoc 错误 编码gbk的不可映射字符
- 百度分享插件,微信,人人网,新浪微博等等
- Java的内存泄露和内存溢出
- 关于提交页面刷新问题
- SD工具类
- 第2章-创建和销毁对象