Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Need help w/ a trigger

Need help w/ a trigger

From: <kirk_at_kaybee.org>
Date: 2000/02/15
Message-ID: <88codp$bgg$1@news-int.gatech.edu>#1/1

What I want to do is basically maintain a version number for a table. If the table is changed in any way, I want the version number to be incremented.

The best way I can think of is to first have a sequence to generate the sequential numbers. Unfortunately, I guess I would have to store the "version number" in another table with that being the only row and column.

If this is the case, I would need to setup a trigger so that, upon any change to the table, it would increment that version number.

I could use help on the theory (is it the best way to do it?) and also writing the trigger (as I never have before).

-- 
 Kirk Bauer -- CmpE, Georgia Tech -- kirk_at_kaybee.org -- Avid Linux User
    GT Sport Parachuting Club!  http://cyberbuzz.gatech.edu/skydive
     Opinions expressed are my own, but they should be everybody's.
Received on Tue Feb 15 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US