Re: History functionality

"Philipp Gath" <ph.gath_at_t-online.de> a écrit dans le message de news:opr4hwfblfjlr53w_at_news.t-online.de...
> Hi,
>
> i'm currently working on a little Database project for my diploma. Now i
> need to have a history funtionality for a few of my tables. This must
> include the old values, time and date of change and user who changed the
> value.
>
> Has anyone an idea how to realize such a functionality in an "as
> intelligent as possible" way? Or maybe a good tip for literatur regarding
> this problem?
>
> Thanks in advance.
>
> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

[Quoted] Have a look at triggers:

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_76a.htm#SQLRF01405
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg13trg.htm#526
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adg13trg.htm#1075

Regards
Michel Cadot Received on Sun Mar 07 2004 - 15:41:47 CET