User Tools

Site Tools


oracle:sql:sequence:create_sequence

Oracle - SQL - Sequence - Create Sequence

CREATE SEQUENCE sequence-name;

CREATE SEQUENCE schema_name.sequence_name
[INCREMENT BY INTERVAL]
[START WITH first_number]
[MAXVALUE max_value | NOMAXVALUE]
[MINVALUE min_value | NOMINVALUE]
[CYCLE | NOCYCLE]
[CACHE cache_size | NOCACHE]
[ORDER | NOORDER];
CREATE SEQUENCE id_seq
    INCREMENT BY 10
    START WITH 10
    MINVALUE 10
    MAXVALUE 100
    CYCLE
    CACHE 2;
oracle/sql/sequence/create_sequence.txt · Last modified: 2021/08/11 11:00 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki