我对触发器不是很熟悉！请高手帮帮忙！谢谢了！create or replace trigger tri_name before inser on table_a for each row insert into table_b(:new.col1,..,:new.coln); end; insert 还一个begin 你太懒了 insert修改为update :new修改为:old SQL code: CREATE TRIGGER [TRIGGER_UPDATE_TableA] BEFORE INSERT ON [TableA] FOR EACH ROW INSERT INTO[TableB](); END
谢谢楼上修正 中午没睡觉 晕晕的 呵呵 create or replace trigger trigger_update_name before update on table_name for each row begin insert into old_data_talbe values(:old.column_name,..); end;
