oracle怎样用触发器将一张表的数据添加到另外一张表中？
好吧，我就假设你两个表的数据结构相同吧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 addDataafter insert on tabA begininsert into tabB select * from tabA;end插入测试语句insert into tabA values ('123','123','123');可直接复制代码
