CREATE OR REPLACE TRIGGER CLASS.DELETE_CLASS
BEFORE INSERT OR DELETE ON CLASS.CLASS
begin
delete from class.class_test ;
insert into class.class_test select * from
ld;
end;
class是个一用户
class.class 和class_delete_class 表结构一样
这个解发器主要是当class.class 删除时,将删除的内容插入class_delete_class 中.
当我编译时总是有错.
What the Id in your script mean?
This one is syntax error free:
CREATE OR REPLACE TRIGGER DELETE_CLASS
BEFORE INSERT OR DELETE ON CLASS
begin
delete from class_test ;
insert into class_test select * from class;
end;
