CREATE TABLE BUILDING(bname VarChar2(30) PRIMARY KEY, address VarChar2(30), phone number Number(15));
i write this code in sql command of oracle application express.
but there is a error
ORA-00907: missing right parenthesis

anyone help me please
i am new in oracle world

Invalid column name phone number. You can use space separated column name inside bockqoutes e.g. CREATE TABLE BUILDING(bname VarChar2(30) PRIMARY KEY, address VarChar2(30), "phone number" Number(15));

cool posts .. thanks guys for the posts .,, they are quite interesting and useful..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.