How to recognize newly-entered records in the table?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How to recognize newly-entered records in the table?

  1. #1
    Join Date
    Nov 2002
    Posts
    3

    Question How to recognize newly-entered records in the table?

    I have system with several data-entry forms in Oracle. I need to write a trigger or a view for the user which will allow user to see all the records that were just been entered by this user in the end of the data-entry process. How I can recognize newly-entered records in the table?
    Thanks a lot!

  2. #2
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    Add an INSERT trigger that populates an INSERTED_TS column with the SYSDATE. Then define what 'new records' means and add the predicate WHERE INSERTED_TS > SYSDATE - :RANGE

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

Posting Permissions

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



Click Here to Expand Forum to Full Width