How to create sequence in oracle?

Question

Amit Singh · Answer

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

The syntax for a sequence is:

CREATE SEQUENCE sequence_name
    MINVALUE value
    MAXVALUE value
    START WITH value
    INCREMENT BY value
    CACHE value;

interview

How to create sequence in oracle?

Can you answer this question?

1 Answers