oracle+多表+更新,Oracle中多表联合更新处理方法详解

ORACLE中多表关联更新与SQL

Server和MYSQL的语法稍有不同，现将ORACLE中多表关联更新的几种方法处理如下：

一、创建测试表和添加测试数据

CREATE TABLE t_test01(

user_id varchar2(20) primary key,

user_name varchar2(10),

remark varchar2(100) default null

);

INSERT INTO t_test01

SELECT '1001','jiajia','你好啊' FROM dual

UNION ALL

SELECT '1002','maimai','' FROM dual

UNION ALL

SELECT '1003','yangyang','' FROM dual

UNION ALL

SELECT '1004','qianqian','' FROM dual

UNION ALL

SELECT '1005','huahua','' FROM dual;

COMMIT;

SELECT * FROM t_test01

CREATE TABLE t_test02(

user_id varchar2(20),

user_name varchar2(10),

address varchar2(100) default null

)

INSERT INTO t_test02