历史数据迁移 使用触发器 trigger 示例

1.

create table tiger1(

  t_id number primary key not null,
  t_name varchar2(10)
);

create table tiger1_histroy(
  t_id number primary key not null,
  t_name varchar2(10)
);

create or replace trigger tr_tiger1
before delete on tiger1
for each row
begin
  insert into tiger1_histroy(t_id,t_name) values(:old.t_id,:old.t_name);
end;
 
  迁移完记得清空下空数据 delete from tiger1 where id=' 'or id is null;
 
  insert into tiger1(t_id,t_name)values(1,'zhangsan');
   insert into tiger1(t_id,t_name)values(2,'zhangsan');
    insert into tiger1(t_id,t_name)values(3,'lisi');
    
    delete from tiger1 where t_id=2
    

    select * from tiger1_histroy

2.

insert into 表名1（id，name,createtime,updatetime,exprot,...）

select id,createtime,updatetime,exprot '专家（写死做别名）' from 表名2

迁移完记得清空下空数据

delete from 表名1 where  exprot =' 'or exprot is null