CODEWITHSUNDEEP
sqldatabaseoracle-databasesyntax-error
nbhuiya
nbhuiya

Reputation: 39

SQL Error Missing Right Paretheses

I am just learning SQL and when I try to create the "Order" table I get the error "missing right parentheses". When I remove the FK constraint I get the error "invalid identifier"

DROP TABLE CUSTOMER;

CREATE TABLE CUSTOMER
(
CUST_ID INT PRIMARY KEY,
COMP_NAME VARCHAR(40),
CONT_LNAME VARCHAR(30),
CONT_FNAME VARCHAR(30),
PHONE VARCHAR(30),
EMAIL VARCHAR(40),
ADDRESS VARCHAR(40),
CITY VARCHAR(30),
ZIP NUMBER
);

INSERT INTO CUSTOMER (CUST_ID, COMP_NAME, CONT_LNAME, CONT_FNAME, PHONE, EMAIL, ADDRESS, CITY,ZIP) VALUES 
(1,'Atomic Liqours','Signor','Rose','518-990-8765','[email protected]','76 Hackett Blvd','Albany','12204');
INSERT INTO CUSTOMER (CUST_ID, COMP_NAME, CONT_LNAME, CONT_FNAME, PHONE, EMAIL, ADDRESS, CITY,ZIP) VALUES 
(2,'HBD Bar','Capozolli','Rose','889-908-6666','[email protected]','888 Project Rd','Troy','12180');
INSERT INTO CUSTOMER (CUST_ID, COMP_NAME, CONT_LNAME, CONT_FNAME, PHONE, EMAIL, ADDRESS, CITY,ZIP) VALUES 
(3,'Lee Harvey','Smith','Seth','675-888-9999','[email protected]','78 Healy Ave','Troy','12222');
-- CREATING ORDER TABLE
CREATE TABLE ORDERS
(
ORD_ID INT PRIMARY KEY,
CUST_ID INT FOREIGN KEY REFERENCES Customers (CUST_ID),
ORD_DATE DATE,
DEL_DATE DATE,
);

Upvotes: 0

Views: 50

Answers (1)

Vasyl Moskalov
Vasyl Moskalov

Reputation: 4630

Looks like your have a typo in your script. Your table name is CUSTOMER, but in CREATE TABLE you references to CUSTOMERS. So, I think that your create table statement must looks like:

CREATE TABLE ORDERS
(
ORD_ID INT PRIMARY KEY,
CUST_ID INT FOREIGN KEY REFERENCES Customer (CUST_ID),
ORD_DATE DATE,
DEL_DATE DATE,
);

Upvotes: 1

Related Questions