Re: Timestamp

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 03 Nov 1999 08:30:25 -0800
Message-ID: <38206321.F44BEE88@us.oracle.com>

Isabelle

The easiest approach is to use a trigger to populate an extra date column to store the timestamp.

Pete

Isabelle wrote:

> All,
>
> I am working for a new datawarehouse project and I am currently
> exploring how we can transfer data from one db to another.
> Source DB is currently under Oracle.
>
> When I connect to the source DB I would like to know what has
> changed since my last connection. Currently the application who
> is managing this DB does not handle that.
>
> I heard there is perhaps a method / option in the Oracle system
> to indicate that we want for each row to keep a timestamp.
>
> Could someone give me indication on : how to put this system in place
> and then how to retrieve the information ?
>
> Thanks by advance
> Isabelle.
>
> -- -- -- -- -- -- --
> Isabelle Fernandez
> Datawarehouse Project
> SEMA Group, Sophia Antipolis, France
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Wed Nov 03 1999 - 10:30:25 CST