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

I want to create trigger for order_history table , but I'm not sure how to do it

What do you want this trigger to do? You cannot use a trigger to update the same table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.