Skip to end of metadata
Go to start of metadata


Overview

ALTIBASE HDB Sequence is almost similar to the Oracle's one

Example

ORACLE

ALTIBASE HDB

CREATE SEQUENCE seq1
START WITH 1000
INCREMENT BY 1
NOCACHE
NOCYCLE;

CREATE SEQUENCE seq1
START WITH 1000
INCREMENT BY 1
NOCACHE
NOCYCLE;

The comparison of each clause regarding sequence

ORACLE

ALTIBASE HDB

Consideration

INCREMENT BY

INCREMENT BY

 

START WITH

START WITH

After initial creation of sequence, this value can't be modified.

MAXVALUE

MAXVALUE

 

NOMAXVALUE

NOMAXVALUE

 

MINVALUE

MINVALUE

 

NOMINVALUE

NOMINVALUE

 

CYCLE

CYCLE

 

NOCYCLE

NOCYCLE

 

CACHE

CACHE

 

NOCACHE

NOCACHE

 

ORDER

not supported

 

NOORDER

not supported

 

  • No labels