Does anyone know if oracle saves "last modified" data? I want to use this in a archiving tool by only querying for data after/before certain dates.
Printable View
Does anyone know if oracle saves "last modified" data? I want to use this in a archiving tool by only querying for data after/before certain dates.
If you are using Oracle 10g, this might be of interest:
http://www.builderau.com.au/program/...9271944,00.htm
Otherwise, add a column that holds a timestamp.
Hi all.
In addition what andreasblixt said, you might add a trigger on your table that updates the timestamp field during INSERT / UPDATE operations.
Thanks for the reply.The problem is solved.:)