SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help
An online community of DBAs, developers and data intelligence builders, with videos, articles, resources and online events for members and non-members.
Find out more >>
(stewashton) Some optimistic locking methods, including the SCN method, can detect intervening updates even when column values have not really changed. With the SCN method, we can use flashback queries to confirm that real changes occurred.