+ Reply to Thread
Results 1 to 2 of 2
  1. 05-05-2003 11:23 AM #1
    sun77
    sun77 is offline Junior Member
    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!
    Reply With Quote Reply With Quote
  2. 05-05-2003 11:28 AM #2
    chrisrlong's Avatar
    chrisrlong
    chrisrlong is offline
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

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

Forum Rules

 Click Here to Expand Forum to Full Width