-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|