Error while creating oracle sequence using datatype BIGINT

Question

Have an error while trying to create Oracle sequence

CREATE SEQUENCE HR.order_entry_id
             AS BIGINT START WITH 1 INCREMENT BY 1;

CREATE SEQUENCE HR.USER_PROFILE_SEQ
             AS BIGINT START WITH 1 INCREMENT BY 1

Error at line 1 ORA-00933: SQL command not properly ended

Is there an issue with this create statement?

Justin Cave · Accepted Answer · 2014-05-15 21:45:16Z

1

First, bigint is not a data type in Oracle. Second, the create sequence DDL statement does not accept an as <<data type>> clause.

CREATE SEQUENCE hr.order_entry_id
  START WITH 1
  INCREMENT BY 1

Since you're not overriding the default start with or increment by, you can also just do

CREATE SEQUENCE hr.order_entry_id

answered May 15, 2014 at 21:45

Justin Cave

233k25 gold badges378 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Error while creating oracle sequence using datatype BIGINT

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related