4. Understanding the Elements of SQL Statements : Expressions in SQL : Sequence Expressions : Locking and Sequences
 
Share this page                  
Locking and Sequences
In applications, sequences use logical locks that allow multiple transactions to retrieve and update the sequence value while preventing changes to the underlying sequence definition. The logical lock is held until the end of the transaction.