Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Help me check my SQL statement. I have error and it cant run. But I dont know whats's the error. As soon as possible. Thank

Help me check my SQL statement. I have error and it cant run. But I dont know whats's the error. As soon as possible. Thank You.

DROP table Order;

CREATE TABLE Order

( OrderID Char(10) not null,

CustomerNo Varchar(25),

Package Varchar(25),

PaymentDate Varchar(25),

PRIMARY KEY (OrderID),

FOREIGN KEY (CustomerNo) references Customer(CustomerNo));

insert into Order

values('B01', 'A05', 'Premium' ,'to_date('14-Jun-2019', 'dd-Mon-YYYY');

insert into Order

values('B02','A01','Premium','to_date('5-April-2020', 'dd-Mon-YYYY');

insert into Order

values('B03','A06','Premium','to_date('8-March-2020', 'dd-Mon-YYYY');

insert into Order

values('B04','A03',NULL,'to_date('3-Jan-2019', 'dd-Mon-YYYY');

insert into Order

values('B05','A02','Premium','to_date('19-May-2020', 'dd-Mon-YYYY');

insert into Order

values('B06','A04',NULL,'to_date('13-Jun-2020', 'dd-Mon-YYYY');

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

The Database Experts Guide To SQL

Authors: Frank Lusardi

1st Edition

0070390029, 978-0070390027

More Books

Students also viewed these Databases questions

Question

How can managers change organizational cultures?

Answered: 1 week ago