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 :
I'm using this syntax, but I'm getting an error.
SQL> Create or Replace Sequence ID
Start with 1
Increment by 1
ERROR: ORA-00922: missing or invalid option
Can someone help me?
Click Here to Expand Forum to Full Width