Friday, 23 August 2013

invalid identifier for creating table

invalid identifier for creating table

create table ROOM
(NO_ROOM INT PRIMARY KEY, TYPE VARCHAR2(8) NOT NULL, SIZE VARCHAR2(8) NOT
NULL)
;
I get ORA-00904, i think problem is from NO_ROOM. I try to use NUMBER,
it's same.
PS. I make table for room that has no.room type and size.

No comments:

Post a Comment