Trigger

Quote:

---

Originally posted by margraf
I didn't understand, can you explain?


I want to do delete cascade without use this clause, I want to create a trigger for this...... Because sometimes I have values in the second table that no appear in the first table..

---

CREATE OR REPLACE TRIGGER bdr BEFORE DELETE ON my_table FOR EACH ROW
BEGIN
DELETE FROM other_table WHERE other_table.col1 = :OLD.col1;
END;