ORA-00907: missing right parenthesis

[arjenkeijman]

Hello everybody,

Im trying to run a sql-script, but every time I runs it, I get the following errormessage.

"mountain_range_ID INTEGER GENERATED ALWAYS AS IDENTITY *
ERROR at line 2:
ORA-00907: missing right parenthesis"

Could anyone tell me what is wrong with my code?
Here is the particular part of the code:

CREATE TABLE mountain_range (
mountain_range_ID INTEGER GENERATED ALWAYS AS IDENTITY
(START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999
NO CYCLE),
mountain_range_name VARCHAR (25) NOT NULL,
location VARCHAR (25) NOT NULL
description VARCHAR (200)
CONSTRAINT mountain_range_PK PRIMARY KEY (mountain_range_ID)
)
;

thank you in advance,

[debasisdas]

Thatr code is not supported in ORACLE.

[amitpatel66]

Hello everybody,

Im trying to run a sql-script, but every time I runs it, I get the following errormessage.

"mountain_range_ID INTEGER GENERATED ALWAYS AS IDENTITY *
ERROR at line 2:
ORA-00907: missing right parenthesis"

Could anyone tell me what is wrong with my code?
Here is the particular part of the code:

CREATE TABLE mountain_range (
mountain_range_ID INTEGER GENERATED ALWAYS AS IDENTITY
(START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999
NO CYCLE),
mountain_range_name VARCHAR (25) NOT NULL,
location VARCHAR (25) NOT NULL
description VARCHAR (200)
CONSTRAINT mountain_range_PK PRIMARY KEY (mountain_range_ID)
)
;

thank you in advance,

You can create a SEQUENCE that
START WITH 1
INCREMENT BY 1
MINVALUE 1
MAXVALUE 99999
NO CYCLE

And make use of this sequence for generating a value of mountain_range_ID while inserting records in to the table