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!

* Deleting rows of a table*

614945Dec 12 2008 — edited Dec 12 2008

hi all

I have a table X. it has some child tables say Y,Z and all are connected through foreign keys.
now if I try to delete a row in parent table, it does not allow me to delete that row as the foreign key constraint is there.
I have not applied ON DELETE CASCADE option on foreign keys when i created them and now i can not alter those.

Is there any command by which i can delete the row in the parent table.

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 9 2009

Added on Dec 12 2008

4 comments

294 views