Ratzz
Ratzz

Reputation: 31

ORA-00904: : invalid identifier while table creation

CREATE TABLE T_Option_Details (
  Option_Id    NUMBER(2),
  Question_ID  INTEGER NOT NULL,
  Option       VARCHAR2(500) NOT NULL);

Error at line 3 ORA-00904: : invalid identifier

Upvotes: 0

Views: 557

Answers (1)

Dba
Dba

Reputation: 6649

OPTION is an oracle reserved keyword, Try with some other column name like this,

CREATE TABLE T_Option_Details(
     Option_Id   NUMBER(2),
     Question_ID INTEGER NOT NULL,
     OPTION_N      VARCHAR2(500) NOT NULL) 

Upvotes: 2

Related Questions