Skip to Main Content

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!

how to temporarily disable on delete cascade but not the constraint

3351Feb 5 2004 — edited Feb 6 2004
Hi all

i would like to know if this is possible

how to temporarily disable on delete cascade but not the constraint

i want to delete a row from the primary key table but i dont want the data from the foreign key to be deleted even though there is an on delete cascade set.

how do i temporarily disable on delete cascade from firing without disabling the constraint


Rgrds

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2004
Added on Feb 5 2004
6 comments
1,288 views