Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Professional Microsoft SQL Server 2012 Administration

Authors: Adam Jorgensen, Steven Wort

1st Edition

1118106881, 9781118106884

More Books

Students also viewed these Databases questions

Question

List and briefly describe three ways to deploy a new system.

Answered: 1 week ago