
SEQUENCE Sequence is a database object and users use this to genearte unique integer numbers randomly. When a sequence no is generated, the sequence no is incremented independent of transaction committing or rooling back. so if the transaction is rolled back there would be missing sequence no in table. To create a Sequence in own …
Continue reading Oracle Sequence