Re: Optimistic locking with ora_rowscn
- From: David Ballester <ballester.david@xxxxxxxxx>
- To: tony@xxxxxxxxxxxxxxx
- Date: Wed, 17 Feb 2010 12:28:04 +0100
2010/2/17 Tony Sequeira <tony@xxxxxxxxxxxxxxx>
> Hi,
>
> I'm involved with the development of a web based application, which will
> update tables in an 11gR2 database.
>
> The proposal is to use a timestamp column which will be checked prior to an
> update.
>
> I believe that using ora_rowscn is a "better" way to do this.
>
> I would like to recommend that we use it instead.
>
> Anyone use it? Any gotchas?
>
>
Historical data?
What's about a backup/restore, reset logs... database new incarnations, etc?
D.
Other related posts:
