Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Need help w/ a trigger
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
![]() |
![]() |