Home » SQL & PL/SQL » SQL & PL/SQL » How delete in cascade the records in the tables when they are in relationship
How delete in cascade the records in the tables when they are in relationship [message #36525] Mon, 03 December 2001 04:37 Go to next message
Gianni
Messages: 7
Registered: November 2001
Junior Member
Hi there,
I would to know how delete in cascade the records in the tables when they are in relationship.
Thanks in advance,
Gianni

----------------------------------------------------------------------
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 Go to previous message
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.

----------------------------------------------------------------------
Previous Topic: Help me problem with metadata and columns
Next Topic: How to copy data from remote database to my local system
Goto Forum:
  


Current Time: Tue Mar 31 11:43:26 CDT 2020