Home » SQL & PL/SQL » SQL & PL/SQL » deleting child records directly
deleting child records directly [message #212252] Thu, 04 January 2007 06:07 Go to next message
white
Messages: 13
Registered: October 2006
Junior Member

Hi,

If EMP is the master table .and DEPT is the child table.
Then my question is when i delete rows in master table,
automatically the rows existing in the child table should be
removed. Is it possible in oracle9i.


Thanks in advance,
Re: deleting child records directly [message #212256 is a reply to message #212252] Thu, 04 January 2007 06:14 Go to previous message
dhananjay
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member
hi,

search for on delete cascade.



regards,
Previous Topic: Advanced queries in sql
Next Topic: Duplicate rows
Goto Forum:
  


Current Time: Sun Dec 11 00:40:58 CST 2016

Total time taken to generate the page: 0.05091 seconds