>As such, most DBA's will look to use one of these other methods before >resorting to a trigger.
you know, i've never thought of it as "resorting" to a trigger. i just use them for what they're good for, and i don't use them for what they're not good for. it's worked for me so far. I can't say i've ever come across anything from oracle telling me that triggers are now deprecated - just the usual stuff about mutating tables (which has been there since at least version 8). Maybe we should turn this upside down: what's wrong with triggers (in Oracle)? /t >-----Original Message----- >From: G [mailto:[EMAIL PROTECTED] >Sent: Monday, April 18, 2005 6:30 PM >To: CF-Talk >Subject: Re: SQL Triggers (was Re: Last ID inserted) > >You prove my point perfectly. Triggers can and do work. Many >legacy systems >make extensive use of triggers, often with good results. >However, in most >new systems, the actions formerly performed by triggers are >being replaced >by other functionality. > >As such, most DBA's will look to use one of these other methods before >resorting to a trigger. > >> >You know a DBA who recommends and actively promotes using >>>triggers? I don't. >> >> Well, i do. >> >> We use triggers with autonomous transactions to log failed >attempts to >> modify rows without the overhead of Oracle supplemental >logging. In the >> past, we have used triggers to perform "tricky" data checks, although >> now we are starting to use more function based indexes and >constraints >> (on new projects - on the old projects the triggers are still there - >> and they still work). Although i've never used them >personally, Oracle >> relies on INSTEAD OF triggers to implement modifiable views. No, we >> don't use triggers to get the ID of the row we just inserted (we just >> use the syntax "RETURNING ID INTO varname"). >> >> /t >> >> >>>-----Original Message----- >>>From: G [mailto:[EMAIL PROTECTED] >>>Sent: Monday, April 18, 2005 4:54 PM >>>To: CF-Talk >>>Subject: Re: SQL Triggers (was Re: Last ID inserted) >>> >>>You know a DBA who recommends and actively promotes using >>>triggers? I don't. >>> >>> >>>> >Trust me. Triggers in the DB world are not looked on as >>>good practive. >>>> >>>> The Microsoft SQL Server world is not the "DB world". >>>> >>> >>> >>> >>> >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:203348 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
