问通过DB链接从相关远程表中移动数据

EN

create table a_rem ( aid number, acontent varchar2(10) );
create table b_rem ( bid number, aid number, bcontent varchar(10) );

create table a_loc ( aid number, acontent varchar2(10) );
create table b_loc ( bid number, aid number, bcontent varchar(10) );

insert into a_rem values ( 1, 'A-One' );
insert into a_rem values ( 2, 'A-Two' );
insert into a_rem values ( 3, 'A-Three' );

insert into b_rem values ( 1, 1, 'B-One' );
insert into b_rem values ( 2, 1, 'B-Two' );
insert into b_rem values ( 3, 2, 'B-Three' );
insert into b_rem values ( 4, 3, 'B-Four' );
insert into b_rem values ( 5, 3, 'B-Five' );

commit;
-- look Ma, no data integrity! :(

-- let us pretend I want to move a_rem.aid = 2 information from both tables
declare
   cursor row_level_locks is 
   select a.*, b.* 
     from a_rem a, b_rem b 
    where a.aid = b.aid and a.aid = 2 
      for update;
begin
   open row_level_locks; -- begins transaction, obtains proper row level locking
   insert into a_loc select * from a_rem where aid = 2;
   insert into b_loc select * from b_rem where aid = 2;
   delete a_rem where aid = 2;
   delete b_rem where aid = 2;
   commit;
   close row_level_locks;
end;