I have a database with some tables and also data in them.I need to implement for all tables optimistic concurrency.
I was wondering what would be the best way.
Query with a predicate will be created on the application side.
My concern is how-to store the rowversion(timestamp) value.
First I was thinking of using ora_rowscn for rowversion value,but then I realised I have to recreate all tables to set up ora_rowscn. Maybe just adding a some kind of timestamp column would be good,but then I would be forced to create and save a new timestamp value for every update in the application.
Any ideas ?