Reputation: 31
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
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