oracle多字段数值比较,oracle两张结构完全相同表，判断比较字段，如果字段不同，则将数据放入第三张表...

需求：oracle两张结构完全相同表，判断比较字段，如果字段不同，则将数据放入第三张表

https://blog.csdn.net/qq_15003505/article/details/80471649

---------------------------------------------------------------------------------------------------------------------------------------------------------------------

演示数据

create table t1(

user_id integer not null,

first_name varchar(20),

last_name varchar(20),

grade varchar(20),

constraint tA1_pkey primary key(user_id)

)

create table t2(

user_id integer not null,

first_name varchar(20),

last_name varchar(20),

grade varchar(20),

constraint tA2_pkey primary key(user_id)

)

insert into t1(user_id,first_name,last_name,grade)values(1,'Some','Dude','A');

insert into t1(user_id,first_name,last_name,grade)values(2,'Other','Guy&#