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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Delete records from child/parent table

sarvanAug 29 2011 — edited Aug 29 2011
Whenever we try to delete records in a parent table that has references in one or more child tables, it will throw an exception,

ORA-02292: integrity constraint (SCHEMA.TABLE_FK1) violated - child record found

I have a requirement in which I will delete records from Parent table and it has to delete records from the corresponding child tables without raising the above said exception

database : Oracle 11g

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 26 2011
Added on Aug 29 2011
9 comments
31,262 views