Re: Timestamp on Oracle database

• Create a numeric field in any table that you would like to control, lets call that field 'updates_count'
• When you insert a record, set 'updates_count' to 0.
• When you query a record, save 'updates_count' in a variable, 'old_updates_count'
• When you update a record check the 'updates_count' field agains 'old_updates_count' 'old_updates_count' = 'updates_count' ----> OK 'old_updates_count' <> 'updates_count' ----> UPDATED
• Don't forget to increase 'updates_count' in the DB and to update the variable 'old_updates_count' with the new value.

UPDATE table_name
  SET any_field = new_value

        updates_count = updates_count + 1
  WHERE pk = pk_value
    AND updates_count = old_updates_count

if SQL%ROWCOUNT = 1 then
  OK
else
  record delete or updated by another user end if;

Hope this help

Javier Rojas.

Veronica escribió:
>
> On the Oracle database, is a timestamp automatically generated whenever
> a user makes inserts/updates to a table? If so, where is this timestamp
> stored?
>
> I'm trying to develop a client application that accesses an Oracle
> database... I need to make sure that no 2 users are modifying the same
> record simultaneously (thats why I need to check the timestamp). I read
> somewhere that one way is to have 3 additional rows in each table:
> 1. TransactionUserName
> 2. TransactionTime ( I guess that's something like generating your own
> timestamp?)
> 3. TransactionFlag
> Apart from this method, are there any alternatives?
Received on Wed Dec 02 1998 - 05:47:53 CST