Search Again: Re: ON DELETE CASCADE command From: Venkat Rao K Date: Friday, April 2, 2004 Time: 8:43:06 pm Hi Depending on the situation we can use the ON DELETE CASCADE. When we = want to delete the parent record automatically the child records also = deleted when we use the ON DELETE CASCADE. Thanks Venkatrao -----Original Message----- From: Johnathan Marvin [mailto:americo74@hotmail.com]=20 Sent: Saturday, April 03, 2004 10:06 AM To: ORACLE-APPS-L@OpenITx.com; oracle-list@digitalpoint.com Subject: [Oracle] ON DELETE CASCADE command I'm a little confused... so i'd like to ask what may sound like a = strange=20 question. When creating tables and using constaints such as primary key , foreign = key,=20 unique key and check key would you aways use after the foreign key=20 constraint the ON DELETE CASCADE command or is there only certain = specific=20 instances where this should and should not be used ? thanks JJ _________________________________________________________________ Check out MSN PC Safety & Security to help ensure your PC is protected = and=20 safe. http://specials.msn.com/msn/security.asp ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ---------------------------------------------------------- ---------------------------------------------------------- To subscribe, unsubscribe or to search list archive please visit http://www.digitalpoint.com/lists/oracle.html ----------------------------------------------------------

Messages In This Thread: ON DELETE CASCADE command by Johnathan Marvin on Apr 2, 2004 at 8:36:38 pm Re: ON DELETE CASCADE command by Venkat Rao K on Apr 2, 2004 at 8:43:06 pm