"SQL command not properly ended" SEQUENCE Creation Random Error
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;
The syntax is:
You want NOMAXVALUE rather than NO MAXVALUE.