"SQL command not properly ended" SEQUENCE Creation Random Error

Question

Was creating a sequence that basically auto increments by 10. Tried to run it, but it gave the error

SQL command not properly ended

Not sure where I went gone wrong here, and I've been at this problem for a while, analyzing for spelling errors, adding commas even though sequence creations for oracle don't need commas, checking for spaces, etc. Yet no success.

What exactly is the problem with this code?

CREATE SEQUENCE emplevel_seq
MINVALUE 1
NO MAXVALUE
START WITH 1
INCREMENT BY 10
CACHE 10;

MT0 · Accepted Answer · 2022-01-05 13:46:56Z

1

The syntax is:

You want NOMAXVALUE rather than NO MAXVALUE.

answered Jan 5, 2022 at 13:46

MT0

173k12 gold badges70 silver badges136 bronze badges

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

2 Comments

Thanos Over a year ago

Tried it and it worked, thank you man. Weird part about the "NO MAXVALUE" bit is that I found it like that on some Oracle SQL explanation site. Thanks for showcasing the entire diagram relating to the commands though

EdStevens Over a year ago

"Thanks for showcasing the entire diagram relating to the commands" Hopefully this will have taught you the value of checking the documentation yourself.

Collectives™ on Stack Overflow

"SQL command not properly ended" SEQUENCE Creation Random Error

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related