Create a trigger on Oracle Databae that updates the field in a table when a field in onether table i
- by GigaPr
Hi,
i have two tables
Order(id, date, note)
and
Delivery(Id, Note, Date)
I want to create a trigger that updates the date in delivery when the date is updated in Order
I was thinking to do something like
CREATE OR REPLACE TRIGGER your_trigger_name
BEFORE UPDATE
ON Order
DECLARE
BEGIN
UPDATE Delivery set date = ??? where id = ???
END;
How do i get the date and row id?
thanks
