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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
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!