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
Messages: 13
Registered: October 2006
Junior Member


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
Messages: 635
Registered: March 2002
Location: Mumbai
Senior Member

search for on delete cascade.

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

Current Time: Sun Jul 23 23:44:30 CDT 2017

Total time taken to generate the page: 0.10107 seconds