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

On Fri, 25 Mar 2005 07:20:32 GMT, Kenneth Koenraadt wrote:

>You have an application. A minor correction must be made. It is now
>easier to implement a trigger instead of changing the code. So you do.
>
>Next time you need corrections, another trigger is implemented. And so
>you continue n times.
>
>You now have 2 tracks to housekeep: The original application code AND
>the triggers. One is flow-based, and one is event-based (the
>triggers). And those 2 tracks have to be coordinated. This will get
>more and more tedious over time, as the application logic changes over
>time, mostly in a more complicated direction.

You are talking about triggers, and in reality you seem to be discussing lousy development methods. Those are two completely unrelated issues.

--
Sybrand Bakker, Senior Oracle DBA