Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> How to write trigger for ON_DELETE_CASCADE?

How to write trigger for ON_DELETE_CASCADE?

From: <ajay.sonawane_at_gmail.com>
Date: 15 Jun 2005 22:31:49 -0700
Message-ID: <1118899909.178803.13580@g44g2000cwa.googlegroups.com> 





Hello Experts


I am new in Sql triggers and i would like some help
I have a Table called ITEM and another callded SOURCE


[ITEM]




ItemNo,ItemName,SourceNo



[Source]



SourceNo,Source



i want to create a Trigger so when i delete a record from [SOURCE] all
the records in [ITEM] where item.SourceNo = [SourceNo that I deleted
from SOURCE] will be deleted.



How can i do that?



Regards,


Ajay Sonawane


(Webtech Developers Pvt. Ltd. Pune )
Received on Thu Jun 16 2005 - 00:31:49 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US