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!

SQL - Cascade on delete

711185Aug 18 2009 — edited Aug 19 2009
Hello Guys,

I have a small issue here. There is one parent table with several child tables associated to it. The problem is when defining the relationships the "cascade on delete" constraint was not defined. Now I want to enable it. I mean if I delete anything in the parent table, I want all the associated child rows should also get deleted.

Thanks in advance and appreciate your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 16 2009
Added on Aug 18 2009
12 comments
7,843 views