How do I detect changes to a table?

From: Ã…ge Strand <aage_at_ts.nera.no>
Date: 1998/01/22
Message-ID: <34C70412.ECFE1686@ts.nera.no>#1/1

[Newbie question]

Hi!

I need to be able to detect whether or not a table has changed since the last time I accessed it, so I can determine if I nedd to read it again or not. Some sort of time stamp denoting the last changes (insert/delete/update...etc) to a table would be fine.

Does Oracle do such a thing automatically, or do I have to hack it together myself using triggers or whatever? If I really have to do it myself, what is the best way of doing it?

Please reply by mail to
Ã…ge Strand
aage_at_ts.nera.no Received on Thu Jan 22 1998 - 00:00:00 CST