DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002

    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
    Baltimore, MD USA
    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
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.