Re: History functionality

[Quoted] Philipp Gath wrote:

> 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.

In addition to triggers look at the LT package, usually accessed using the DBMS_WM synonym.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)