Re: Need help w/ a trigger

For completer information on designing and writing triggers, try downloading a trial version of the PL/SQL Knowledge Base from http://www.revealnet.com The PL/SQL Knowledge Base covers 1,400 PL/SQL topics with thousands of reusable examples.

Best wishes,

Cam White
RevealNet, Inc.
kirk_at_kaybee.org wrote in message <88codp$bgg$1_at_news-int.gatech.edu>...
>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 Wed Feb 16 2000 - 00:00:00 CST