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
Get step-by-step solutions from verified subject matter experts
