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

Home -> Community -> Usenet -> comp.databases.theory -> Re: modelling history in a database

Re: modelling history in a database

From: stu <smcgouga_at_nospam.co.uk>
Date: Fri, 14 Feb 2003 09:23:31 -0000
Message-ID: <b2iclb$lkm$1$8302bc10@news.demon.co.uk>

"Jason" <pmorrison_at_4lpi.com> wrote in message news:cf188409.0302131022.3be0e1ad_at_posting.google.com...
> Jan Marten Visser <jan.marten.visser_at_virgil.nl> wrote in message
news:<3E4A2B18.C729DD29_at_virgil.nl>...
> Second, you could create a table Change that has fields for the table,
> field, old data, new data and date of change.
>

I like that idea! Have you tried it in practice? Does anybody else have any comments on this suggestion?

Cheers
Stu Received on Fri Feb 14 2003 - 03:23:31 CST

Original text of this message

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