<div>
If you disable the foreign keys for tables b and c and table a was created with on delete cascade. You should be able to delete the record from table a. However, you would need to delete the child records from b and c before you could re-enable the foreign keys.
</div>


If you disable the foreign keys for tables b and c and table a was created with on delete cascade. You should be able to delete the record from table a. However, you would need to delete the child records from b and c before you could re-enable the foreign keys.

<div>
I meant to say if the delete rule for b and c is not cascade, you would need to remove the child records first before re-enabling.
</div>


I meant to say if the delete rule for b and c is not cascade, you would need to remove the child records first before re-enabling.

<div>
in other terms: with the referential constraints ( foreign key ) enabled, you delete from table a only<br />
<br />
ogherwise you delete from c first, then from b, finally from a
</div>


in other terms: with the referential constraints ( foreign key ) enabled, you delete from table a only

ogherwise you delete from c first, then from b, finally from a

<div>
slightwv is right. I should have stopped my initial response after the second sentence.
</div>


slightwv is right. I should have stopped my initial response after the second sentence.

<div>
<div class="content wysiwyg-content">
Experts,<br />
I have 3 tables say a, b and c. table a has the primary key 'a_id' and table b has the primary key 'b_id' and also foreign key from table a as 'a_id'. Table c has the primary key 'c_id' and the foreign key from table b which is 'b_id'. <br />
If I want to delete a record from table a which has child record in table b and the child record in table b has a child record in table c.<br />
<br />
can it be done in a single delete statement?
</div>
</div>


Experts,
I have 3 tables say a, b and c. table a has the primary key 'a_id' and table b has the primary key 'b_id' and also foreign key from table a as 'a_id'. Table c has the primary key 'c_id' and the foreign key from table b which is 'b_id'. 
If I want to delete a record from table a which has child record in table b and the child record in table b has a child record in table c.

can it be done in a single delete statement?

Oracle delete from tables with referential integrity

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.