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
I wonder if a space is required after the word BUILDING.
https://www.w3schools.com/sql/sql_create_table.asp
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..
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.