|
Re: How delete in cascade the records in the tables when they are in relationship [message #36529 is a reply to message #36525] |
Mon, 03 December 2001 04:54 |
Suresh Vemulapalli
Messages: 624 Registered: August 2000
|
Senior Member |
|
|
oracle automatically deletes rows when referential integrity constraint enforced.
if referential constraint specified on the child table as 'ON DELETE CASCADE' , oralce deletes associated records in child table when master record deleted.
if you are trying without enforcing referential constraint, how oracle knows master ,child relationship.
----------------------------------------------------------------------
|
|
|