create or replace trigger tri_del_deptno after delete on dept1 for each row begin dbms_output.put_line('你删除了'||to_char(:old.deptno)||:old.dname||:old.loc); end; /
就是這樣,不過也可以用一張臨時表記錄下來 sql>create table table_record as select * from your_table; sql>delete from table_record; sql>commit;create or replace trigger tri_del_deptno after delete on your_table for each row begin insert into your_table (col1,col2,...) values (:old.col1,:old.col2,...); commit; end;
sql>create table table_record as select * from your_table;
sql>delete from table_record;
sql>commit;create or replace trigger tri_del_deptno
after delete on your_table
for each row
begin
insert into your_table (col1,col2,...)
values (:old.col1,:old.col2,...);
commit;
end;