Sequence are nothing but which • Automatically generates unique numbers• Is a sharable object• Is typically used to create a primary key value• Replaces application code• Speeds up the efficiency of accessing sequencevalues when cached in memory
Above answer was rated as good by the following members: mittu.jangid
Sequence are nothing but which • Automatically generates unique numbers• Is a sharable object• Is typically used to create a primary key value• Replaces application code• Speeds up the efficiency of accessing sequencevalues when cached in memory
A sequence is a user created database object that can be shared by multiple users to generate unique integers. A typical usage for sequences is to create a primary key value which must be unique for each row. The sequence is generated and incremented (or decremented) by an internal Oracle routine. This can be a time-saving object because it can reduce the amount of application code needed to write asequence-generating routine. Sequence numbers are stored and generated independently of tables. Therefore the same sequence can be used for multiple tables.
1 
0