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!

Need help in deleting multiple tables

789728Aug 5 2010 — edited Aug 6 2010

Hi,
In one of my scenario i want to delete One record from the table, but there are some child and sub child exist for the table. And the on delete cascade is not set fro any of the table.

Structure of my table,
Table-1
tab1_pk
tab1_name

Table-2
tab2_pk
tab1_pk

Table-3
tab3_pk
tab2_pk

i want to delete the record from Table-1 and all the related record of Table-2 and Table-3 in a single query.

Plz help

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2010

Added on Aug 5 2010

#general-database-discussions

5 comments

948 views