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