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
and and and  MINVALUE value
and and and  MAXVALUE value
and and and  START WITH value
and and and  INCREMENT BY value
and and and  CACHE value;

interview

How to create sequence in oracle?

Amit Singh

Can you answer this question?

1 Answers

Liked By