針對數據備份的問題

針對一張表，只要有操作（不論增、刪、改）我就需要備份到新的數據庫，這樣的應該怎么設計，請大家幫我解答一下吧，謝謝

慕萊塢6476293

2017-10-20

源自：Oracle觸發器 2-4

關注問題我要回答

766

操作

收起

1 回答

慕田峪9362115
2019-06-03

create?table?emp1?select?*?from?emp?where?1=2;

create?or?replace?trigger?tri_operation_dml
?after?insert?or?delete?or?update?on?emp
?for?each?row
?begin??
?insert?into?emp1(ename)??select?case?when?:old.ename?is?null?then?:new.ename?else?:old.ename?end??from?dual;
?end;