Isabelle,
Add a last_updated date column to the table(s)
Create a before row trigger for update and insert on the
table(s) which sets
new.last_updated := sysdate;
this will cause the last_updated column to be changed.
Becca
> 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.
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=7483&cus_id=USENET&qtn_id=7994
Received on Mon Nov 08 1999 - 08:39:10 CST
