Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Timestamp on Oracle database
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 - 18:46:16 CST