Question: 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

1 Expert Approved Answer

Step: 1 Unlock

Lets go through your SQL command step by step to identify and correct any issues The error youre receiving ORA00906 missing left parenthesis suggests ... View full answer

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!

CREATE TABLE vendor ( vendor_id int NOT NULL, vendor_name char(50) NOT NULL, contact_name char(50), CONSTRAINT vendors_pk PRIMARY KEY (vendor_id) ); I cant find the foreign key for this table? CREATE...

create table Inventory( I_FlowerNumber number , I_Location varchar(20), I_Condition varchar(20), I_Search varchar(40),I_Delete varchar(20), I_Add number,I_Quantity number,PRIMARY KEY...

1.What is relationships do Steven Kings dependents have with them? 2.How many dependents are in Canada? 3. How many dependents are in Seattle? 4.How many employees do not have children? 5. Which...

Use the ' Premiere Products Company ' SQL script file found in the D2L content folder called 'SQL Scripts'. Paste the contents of this script into a query tab of MySQL Workbench and execute it. This...

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), CONSTRAINT...

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...

drop table order_details; drop table product_order; drop table club_membership; drop table purchase_order; drop table product; drop table customer; drop table club_activity; drop table...

1. Show the total employee in the employees table . 2. Find the employees with multiple records with same email (Hint: using Having) 3. How many unique orders in the orderdetails table. 4.List the...

Page 236: Ex5B-8. Utilize the Outdoor Clubs & Product database to create a procedure "ex5b_supplier_update" that contains two input parameters. The first input parameter is a supplier_id attribute...

DROP TABLE IF EXISTS `offices`; CREATE TABLE `offices` ( `officeCode` varchar(10) NOT NULL, `city` varchar(50) NOT NULL, `phone` varchar(50) NOT NULL, `addressLine1` varchar(50) NOT NULL,...

At pH 0, 1/2 O2 + 2H+ + 2e- H2 O................E = 1.23 V Is oxygen reduction more favored at pH 0 or at pH 7? Explain in electrochemical terms as well as in terms of chemical equilibria.

Where the activities of a taxpayer into the acquisition and sale of property are alleged to constitute the carrying on of a trade, it is necessary to determine after consideration of all the facts of...

The most significant consequence for investors using the global capital market versas the domessic maset is the instios con diventiter portios Internationally, which allows them to reduce their...

MATLAB code please! thanks HW10 4 A uniform beam is simply supported at both ends, and subjected to a load. The deflection of the beam is given by the differential equation 0.4 0.60.8 1.0 y (cm0 7.78...