Re: last modification on row

There is also a function ora_rowscn that can be used to approximate the scn for a row. Once you have an scn that can be converted to a time within 3 seconds using SCN_TO_TIMESTAMP.

You also have the option at table creation time to time to append an scn to every row. This is called row level dependency and is intented for use with replication but if you take action to save off the scn to time data you could then use the saved data to perform scn to time translaction.

If you really want the date/time the last change was made you should probably either use the builtin audit feature or a DML trigger and a history/audit table to capture this fact.

HTH -- Mark D Powell -- Received on Mon Jul 18 2005 - 08:48:30 CDT