好吧,我就假设你两个表的数据结构相同吧
create table TabA
(
address varchar2(50),
press varchar2(50),
city varchar2(50)
)
/
create table TabB
(
address varchar2(50),
press varchar2(50),
city varchar2(50)
)
/
create or replace trigger addData
after insert
on tabA
begin
insert into tabB select * from tabA;
end
插入测试语句
insert into tabA values ('123','123','123');
可直接复制代码
转载于:https://www.cnblogs.com/klxll/p/3156582.html