Overview
ALTIBASE HDB Sequence is almost similar to the Oracle's one
Example
ORACLE |
ALTIBASE HDB |
---|---|
CREATE SEQUENCE seq1 |
CREATE SEQUENCE seq1 |
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 |
|