Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Implementing ON DELETE CASCADE without a foreign key

SM_308Dec 18 2008 — edited Dec 18 2008
DB Version:10gR2

I have two tables DEPT and EMP. I have a requirement in which if i delete a row from DEPT it should be deleted from EMP as well. But when i insert a row into EMP that row doesn't not have to be present in the DEPT table. ie. I don't want a Foreign key, but i just need ON DELETE CASCADE functionality.

Is this possible in any way?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 15 2009
Added on Dec 18 2008
5 comments
536 views