How to make a trigger on the table for the history table [message #672823] |
Sun, 28 October 2018 13:50 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/b14752c368893ad536beeeeba1be6a9f?s=64&d=mm&r=g) |
petar97
Messages: 120 Registered: October 2018
|
Senior Member |
|
|
I have problems creating trigger, after update, after insert and before delete.
Table accounts:
create table accounts (
acc_id number,
acc_name varchar2(32),
acc_amount number,
acc_date date
);
History table:
create table accounts_history (
id number
, old_name varchar2(32)
, new_name varchar2(32)
, old_amount number
, new_amount number
, change_date date
);
|
|
|
|
|
|
|
|
|
|