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
Jump to PostInvalid 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));
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.
