On Tue, 28 Aug 2007 15:33:46 -0000, Matthew Williams
<matthew.d.williams@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