Checking if there has been a change

We have a rather complex PL/SQL batch code that processes entire table and update it. Due to the business logic, after the code updates a particular row, we need to visit that the same row again later and check if it has been changed before. This is done in the same transaction. Due to bureaucracy here, we cannot add another column to the table that we can mark whenever we make changes to the row.

Triggers let you see before value and after value using :OLD and :NEW when you update something. We just need to know whether the row was modified before or not. Is there any way to find this out? Thank you in advance. Received on Tue Sep 01 1998 - 22:18:06 CDT