I have three table
customer
c_id NUMBER
c_name VARCHAR2
c_address VARCHAR2
order
o_id NUMBER
fk_c_id NUMBER
o_name VARCHAR2
o_price NUMBER
o_orderDate DATE
order_history
oh_id
fk_o_id
fk_c_id
oh_status VARCHAR2
oh_dateChanged DATE
When the customer make an order it will show default status as pending then if the status change to approve it will be added to the order_history the date the status changed and c_id,o_id and the status.
I want to create trigger to keep the order_history updated for the user. I alread have three trigger for c_id ,oh_id and o_id