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

----------------------------------------------------------------------

Report message to a moderator

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.

----------------------------------------------------------------------

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 07:34:27 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.