Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Location
    Mumbai,India.
    Posts
    36

    Unanswered: timestamp log???

    Hi,

    Where can i get the information about time&date of insertion/updation of a data in the table?
    Is there any log file to keep this in Oracle?Yes,,then how can i get it?

    Thanks in advance....

  2. #2
    Join Date
    Jan 2004
    Posts
    492

    Re: timestamp log???

    I think the easiest way going forward would be to set up a trigger on a column in the database. Set up a column which has the entered/modified date, and have the trigger populate the columns with the SYSDATE.
    Last edited by ss659; 02-04-04 at 09:06.

Posting Permissions

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