[thesite] last 5 query

[Dean Mah]

I tend to stay away from triggers.  I like to try to separate the
business logic, database layer, and the presentation layer.  Mixing
them usually makes debugging the application more difficult.

However, if you want to implement something like this, it would be
relatively simple.  You could write a PL/SQL or Java stored procedure
to handle it.

Dean


Daniel J. Cody writes:

> there is, but i have no clue how to do it. our main oracle DBA has been
> on vacation for a couple weeks, and i was going to run stuff by him.
> i'll ask him about this too, although i'd wonder if the overhead of the
> trigger would negate any other benefits..
> 
> i'll get this by him tomorrow though, thanks :)