Why can't SQL SELECT's fire triggers
From: Earl Nall <ejn_at_ornl.gov>
Date: 8 Sep 1994 11:26:47 GMT
Message-ID: <34msdn$lau_at_stc06.CTD.ORNL.GOV>
Received on Thu Sep 08 1994 - 13:26:47 CEST
Date: 8 Sep 1994 11:26:47 GMT
Message-ID: <34msdn$lau_at_stc06.CTD.ORNL.GOV>
Oracle allows triggers to be fired when issuing SQL UPDATE, INSERT and
DELETE, but not when doing a SELECT. I also see that this is not
unique to Oracle as Sybase doesn't allow this.
What is the reasoning behind this. It seems logical to me that firing
a trigger from a SELECT would be beneficial in many applications (e.g.
Thanks
Earl Nall Internet.ejn_at_ornl.gov Martin Marietta Energy Systems, Inc. Phone....615-574-8689 Bldg K-1007, Rm 2260-J, MS-7058, PO Box 2003 Fax......615-241-3308Oak Ridge, Tennessee 37831-7058
Received on Thu Sep 08 1994 - 13:26:47 CEST