--对 表changebeforechangeafter重命名为a,b,查找a b,对两张表进行对比
SELECT a.id a,a.name a,b.id b,b.name b
FROM changebefore a
inner join
changeafter b
on a.id = b.id;
create table changebefore (idnumber(4),name varchar2(30));
insert into changebefore values(1,'one');
insert into changebefore values(2,'two');
create table changeafter (id number(4),namevarchar2(30));
insert into changeafter values(1,'one');
insert into changeafter values(2,'two');
commit;
select * from changebefore;
select * from changeafter;
--修改后查询修改的数值
update changeafter set name='twoafter'where id=2;
commit;
select * from changebefore;
select * from changeafter;
--恢复数据使两张表相同
update changeafter set name='two' whereid=2;
commit;
select * from changebefore;
select * from changeafter;
