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