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