Oracle Database Discussions

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!

deleting parent records and leaving child records

514081May 30 2006 — edited May 30 2006

Hi All,

Is there a way to delete parent records in a table when they have child records in another table (without removing the PK/FK)? I know this contradicts the whole point of referential integrity but is there a work around it?

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2006

Added on May 30 2006

#general-database-discussions

15 comments

1,579 views