Question: CREATE TABLE purchase_order (order_number int(11) NOT NULL,order_name char(50) NOT NULL,customer_address char(50),customer_zip int(5) DEFAULT NULL, customer_city char(50) DEFAULT NULL,order_total varchar(50)DEFAULT NULL,V_VendorID VARCHAR(20) DEFAULT NULL,ITEM_NUMBER int(10) NOT

CREATE TABLE purchase_order (order_number int(11) NOT NULL,order_name char(50) NOT NULL,customer_address char(50),customer_zip int(5) DEFAULT NULL, customer_city char(50) DEFAULT NULL,order_total varchar(50)DEFAULT NULL,V_VendorID VARCHAR(20) DEFAULT NULL,ITEM_NUMBER int(10) NOT NULL,PRIMARY KEY (order_number),FOREIGN KEY FK_vendor (V_VendorID) REFERENCES vendor(V_VendorID),FOREIGN KEY FK_inventory(ITEM_NUMBER) REFERENCES Inventory(I_FlowerNumber),CONSTRAINT FK_inventory FOREIGN KEY (ITEM_NUMBER) REFERENCES Inventory (I_FlowerNumber),CONSTRAINT FK_vendor FOREIGN KEY (V_VendorID) REFERENCES Vendor (V_VendorID));

I cant get this code to work? I am getting the error message ORA-00907: missing right parenthesis

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!