<div>
You cannot, that is what is called referential integrity anyway, isn't it? <br />
<br />
The possible work around is to set values to NULL (does not meet the requirement : with out affecting child table).<br />
<br />
<a href="https://www.techonthenet.com/oracle/foreign_keys/foreign_null.php" rel="ugc">Here</a> is a link.
</div>


You cannot, that is what is called referential integrity anyway, isn't it?

The possible work around is to set values to NULL (does not meet the requirement : with out affecting child table).

Here [https://www.techonthenet.com/oracle/foreign_keys/foreign_null.php] is a link.

<div>
Your solution solved my problem as well, thanks!
</div>


Your solution solved my problem as well, thanks!

<div>
<div class="content wysiwyg-content">
I want to delete a record from parent table, I am unable to do so, as I am getting error<br />
how can i delete parent records with out affecting child table<br />
<br />
can you plse any one help me
</div>
</div>


I want to delete a record from parent table, I am unable to do so, as I am getting error
how can i delete parent records with out affecting child table

can you plse any one help me

Referential intigrity

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.