CODEWITHSUNDEEP
oracle-database
MrOnlyonejack
MrOnlyonejack

Reputation: 27

SQL Error: ORA-00906: missing left parenthesis 00906. 00000 - "missing left parenthesis"

i have been trying to make a simple table and i it keeps coming up with SQL Error: ORA-00906: missing left parenthesis 00906. 00000 - "missing left parenthesis"

CREATE TABLE USER_TABLE(
USER_ID int NOT NULL,
Username varchar NULL,
Password varchar NULL, 
Email varchar NOT NULL,
DOB Date NULL, 
Address VARCHAR NOT NULL, 
First_name VARCHAR NOT NULL, 
Telephone_number int NULL,
PRIMARY KEY (User_ID));

Upvotes: 1

Views: 574

Answers (1)

Aleksej
Aleksej

Reputation: 22949

You simply need to add the size of VARCHAR colums:

CREATE TABLE USER_TABLE
(
    USER_ID             INT NOT NULL,
    Username            VARCHAR(1) NULL,
    Password            VARCHAR(1) NULL,
    Email               VARCHAR(1) NOT NULL,
    DOB                 DATE NULL,
    Address             VARCHAR(1) NOT NULL,
    First_name          VARCHAR(1) NOT NULL,
    Telephone_number    INT NULL,
    PRIMARY KEY(User_ID)
);

Notice that VARCHAR is deprecated, better use VARCHAR2

Upvotes: 2

Related Questions