HOW TO CREATE SEQUENCE IN ORACLE?

Amit Singh

Total Post:565

Points:2825
Posted by  Amit Singh
 1512  View(s)
Ratings:
Rate this:
  1. Amit Singh

    Post:565

    Points:2825
    How to create sequence in oracle?

    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;

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!