|
Click to See Complete Forum and Search --> : How to recognize newly-entered records in the table? sun77 05-05-2003, 12:23 PM 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! chrisrlong 05-05-2003, 12:28 PM 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 dbasupport.com
Copyright Internet.com Inc. All Rights Reserved. |
|