Re: Default column value of MAX +1 of column - possible in Oracle 9i?

On Fri, 25 Mar 2005 06:54:57 GMT, Kenneth Koenraadt wrote:

>Hi Arun,
>
>Thanks for the stats. My term "evil" was meant to emphasize the latter
>quote : "Don't use triggers unless you really have to". After all,
>don't use Evilness unless you have to :-)
>
>- Kenneth Koenraadt

So actually you don't have any solid reason to reject them other than superstition. Because in almost all case anyone uses them they *are* needed.

Apart from that the main 'problem' and difference to ordinary PL/SQL is that a trigger is parsed every time it is called. This is easily verified from a TKPROF output. This can be worked around by converting the code in a procedure and calling the procedure from your trigger.

--
Sybrand Bakker, Senior Oracle DBA