Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    52

    Question Unanswered: DateLastModified on a table inside a Database?

    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
    "Never underestimate a large number of morons"

  2. #2
    Join Date
    Jul 2003
    Location
    SoCal
    Posts
    721
    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.
    That which does not kill me postpones the inevitable.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •