replace foreign key with on delete cascade with trigger
Hi Friends,
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.
eg:
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.
Siva prakash