I have created a table with an 'ID' column that is 'NOT NULL' and is of the INTEGER datatype.

I want this column to increment by 1 for every row that it contains.

So if I have 4 rows in my table, the ID colum will look like this :

ID
----
1
2
3
4

I'm using this syntax, but I'm getting an error.

SQL> Create or Replace Sequence ID

Start with 1

Increment by 1

NoMinValue

NoMaxValue

NoCycle

NoCache;

ERROR: ORA-00922: missing or invalid option

Can someone help me?