CREATE SEQUENCE

In Oracle you can create an autonumber field by using sequences.

A Sequence is an object in oracle that is used to generate a number sequence.
This can be useful when we need to create unique number to act as a primary key.

The syntax to create a sequence in oracle is:
Create sequence sequence_name
Minvalue value
Maxvalue value
Start with value
Increment By Value;

For Example:-


Create sequence se1
Minvalue 100
Maxvalue 9999
Start with 100
Increment by 1
Nocache ;

This would create object a sequence called seq1. First sequence would be use as is 100 and increment by 1.

Share this

Hemalata