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

Home -> Community -> Usenet -> c.d.o.server -> Re: Automatic versioning of records to maintain a history

Re: Automatic versioning of records to maintain a history

From: <sybrandb_at_hccnet.nl>
Date: Tue, 28 Aug 2007 23:16:23 +0200
Message-ID: <it39d3t14q2n951eqf7aiumr9phvpubd7j@4ax.com>


On Tue, 28 Aug 2007 15:33:46 -0000, Matthew Williams <matthew.d.williams_at_gmail.com> wrote:

>I'm working with Oracle 10g and need an instance where whenever a
>record is modified I can automatically store a copy of that record and
>assign it a version number. So at any given time I can see a history
>for that given record in the table.
>
>I'm new to Oracle and I would like to avoid writing as much SQL as
>possible if there is some built in functionality of trigger to do
>this.
>
>The front end of the tool is Oracle Forms.... If this were a Ruby on
>Rails app I could simply use acts_as_versioned on my model and wham,
>I'm all set!
>
>Thanks!

In the past Oracle Developer was capable of generating these history tables.
Oracle Enterprise Edition has a feature called Oracle Workspace Manager.
Examples probably on http://www.psoug.org/reference (Morgan's library)

I have developed to a tool to generate those tables and triggers. As I am not in the office I don't have access to it know. It is pretty generic, and you end up with a set of pl/sql with the table definition being referenced as a subtype. Which means: any table Alteration and you only need to recompile (ie not change) that piece of PL/SQL.

-- 
Sybrand Bakker
Senior Oracle DBA
Received on Tue Aug 28 2007 - 16:16:23 CDT

Original text of this message

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