Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CREATE TABLE purchase_order ( order_number int NOT NULL, order_name char(50) NOT NULL, customer_address char(50), customer_zip int, customer_city char (50), order_total varchar(50), vendor_ID VARCHAR(20), ITEM_NUMBER int
CREATE TABLE purchase_order ( order_number int NOT NULL, order_name char(50) NOT NULL, customer_address char(50), customer_zip int, customer_city char (50), order_total varchar(50), vendor_ID VARCHAR(20), ITEM_NUMBER int NOT NULL, CONSTRAINT pk_purchase_order PRIMARY KEY (order_number), FOREIGN KEY fk_vendor(V_VendorID) REFERENCES vendor(V_VendorID) FOREIGN KEY fk_inventory(ITEM_NUMBER) REFERENCES Inventory(I_FlowerNumber) );
I CANNOT GET THIS SQL COMMAND CODE TO WORK. WHAT IS WRONG? I AM GETTING THE ERROR ORA-00906: missing left parenthesis.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started