O'k if you would like to delete cascade you may not use a trigger at all:
Do like that:

ALTER TABLE address_reminder_tbl
ADD ( FOREIGN KEY (rem_id)
REFERENCES reminder_calendar_tbl on delete cascade) ;

And when you delete from the parent table all records will be deleted from the doughters tables.

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..