by Mark D Powell <Mark.Powell@[EMAIL PROTECTED]
>
May 9, 2008 at 06:58 AM
On May 9, 9:45=A0am, alastair.coo...@[EMAIL PROTECTED]
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...@[EMAIL PROTECTED]
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 --
