Oracle merge into 学习
来源:互联网 发布:mhx网络联机 编辑:程序博客网 时间:2024/06/05 18:40
用途
将A表的数据输出到B表中,根据条件判断B表中是否有数据,有则更新,没有则插入
语法
merge into table1 alias1 using table2 alias2 on (condition)when matched then update set col1=col2when not matched then insert (col1) values (col2)
示例
MERGE INTO SCOTT.TEST_USERS m0 USING ( SELECT t0.USERID, t0.USERNAME FROM SCOTT.USERS) m1 ON (m0.USERID = m1.USERID)WHEN MATCHED THEN UPDATESET USERNAME = m1.USERNAMEWHEN NOT MATCHED THEN INSERT (USERID, USERNAME)VALUES (m1.USERID, m1.USERNAME)
阅读全文
0 0
- Oracle merge into 学习
- Oracle select --merge into:
- oracle merge into 测试
- oracle merge into
- oracle merge into 实例
- Oracle 之 MERGE INTO
- Oracle:merge into
- Oracle数据库merge into
- oracle merge into
- oracle merge into
- oracle merge into用法
- merge into(oracle)
- ORACLE MERGE INTO
- oracle merge into 用法
- oracle merge into
- Oracle merge into 命令
- oracle的merge into
- oracle 中的merge into
- 仿微信朋友圈图片点击放大效果
- Wildfly在Linux下以Service的方式启动 配置步骤
- CentOS上Git升级
- linux关闭防火墙或者修改防火墙配置的命令
- 闭包
- Oracle merge into 学习
- 以后开始更新技术博客了
- iOS中block的循环引用问题
- CentOS7下安装MySQL5.7安装与配置(YUM)
- 机器人的移动范围
- 对nodejs开发为什么要使用“包”的理解
- ORA-12505: TNS: 监听程序当前无法识别连接描述符中所给出的 SID
- AndroidStudio Duplicate files copied in APK错误解决方案
- 微信小程序教程、微信小程序开发资源下载汇总(6.16日更新,持续更新中……)