DateLastModified on a table inside a Database?

Td04 · #1 (**permalink**) 06-11-04, 06:30

I would like to get the date when a certain table in a database (oracle) was last changed. Is it possible to use the DateLastModified somhow? or is there some other approach?
Thanks//Martin

Seppuku · #2 (**permalink**) 06-11-04, 11:55

You'd have to have a column in your table that you update whenever you change a field (or you could write an UPDATE trigger to do it automatically). If you don't have it there now, you won't be able to obtain the info for existing data.