Answer:
Sequences are used for generating sequence numbers without any overhead of locking. Drawback is that after generating a sequence number if the transaction is rolled back, then that sequence number is lost.
Previous Question | Next Question |
What is sql Commit? | What is sql Correlated Subquery? |