-
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!
-
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
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
|