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>


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. access control).

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-3308 
Oak Ridge, Tennessee 37831-7058
Received on Thu Sep 08 1994 - 13:26:47 CEST

Original text of this message