replace foreign key with on delete cascade with trigger
It is very long time since i visited this form. i am looking for some idea because of functionality restrictions to replace foreign key with on delete cascade --to--> trigger in 10g.
we have two tables dept and emp table.
emp table has foreign key with on delete cascade enabled
now we want to get same functionality by removing this foreign key but still having delete cascade between emp and dept .
please let me know if this possible
after removing foreign key . child records should be deleted when parent is deleted .
actual setup is i have 1 table grp with 5000 child tables having foreignkey pointing to single column in grp table.
Thanks fro your help.