On May 9, 9:45*am, alastair.coo...@googlemail.com wrote:
> Hi.
>
> We are connecting to an Oracle 9i Database, is it possible to query a
> table to find out the last date / time a row was updated / inserted.
>
> Thanks
>
> Alast...@wavetechconsultancy.co.uk

No, on version 9.2 and lower the only way to know when a row in a
table was changed is to either use a trigger to populate last change
by and when columns on the row or to use the builtin audit command by
access.

Is there a way to get the Date/Time when a row was last updated?
http://www.jlcomp.demon.co.uk/faq/mod_time.html


HTH -- Mark D Powell --