程序代写代做 DROP TABLE Order_Report;

DROP TABLE Order_Report;

CREATE TABLE Order_Report
(Order# CHAR(5),
Order_Date DATE,
CusID CHAR(3),
Cus_Name VARCHAR2(35),
Cus_Email VARCHAR2(25),
Balance NUMBER(8,2),
Credit_Limit NUMBER(8,2),
RepID CHAR(2),
FName VARCHAR2(30),
LName VARCHAR2(30),
Item# CHAR(4),
Name VARCHAR2(15),
Class CHAR(2),
Price NUMBER(6,2),
Num_Ordered NUMBER(3),
Quoted_Price NUMBER(6,2));

INSERT INTO Order_Report VALUES
(‘21608′, ’04-FEB-20’, ‘148’, ‘Al”s Appliances’, ‘alsstore@net.com’, 6550, 7500, ’20’, ‘Valerie’, ‘Kaiser’, ‘AT94’, ‘Iron’, ‘HW’, 24.95, 11, 22.50);
INSERT INTO Order_Report VALUES
(‘21608′, ’04-FEB-20’, ‘148’, ‘Al”s Appliances’, ‘alsstore@net.com’, 6550, 7500, ’20’, ‘Valerie’, ‘Kaiser’, ‘CD52’, ‘Microwave Oven’, ‘AP’, 165, 5, 148.50);
INSERT INTO Order_Report VALUES
(‘21608′, ’04-FEB-20’, ‘148’, ‘Al”s Appliances’, ‘alsstore@net.com’, 6550, 7500, ’20’, ‘Valerie’, ‘Kaiser’, ‘DL71’, ‘Cordless Drill’, ‘HW’, 129.95, 5, 117.00);
INSERT INTO Order_Report VALUES
(‘21610′, ’04-FEB-20’, ‘356’, ‘Ferguson”s’, ‘fergie55@bymail.com’, 5785, 7500, ’40’, ‘Juan’, ‘Perez’, ‘DR93’, ‘Gas Range’, ‘AP’, 495, 2, 495.00);
INSERT INTO Order_Report VALUES
(‘21610′, ’04-FEB-20’, ‘356’, ‘Ferguson”s’, ‘fergie55@bymail.com’, 5785, 7500, ’40’, ‘Juan’, ‘Perez’,’DW11′, ‘Washer’, ‘AP’, 399.95, 2, 399.95);
INSERT INTO Order_Report VALUES
(‘21613′, ’05-FEB-20’, ‘408’, ‘The Everything Shop’, ‘everything@myshop.com’, 5285.25, 5000, ’30’, ‘Richard’, ‘Hull’, ‘DW11’, ‘Washer’, ‘AP’, 399.95, 4, 375.95);
INSERT INTO Order_Report VALUES
(‘21613′, ’05-FEB-20’, ‘408’, ‘The Everything Shop’, ‘everything@myshop.com’, 5285.25, 5000, ’30’, ‘Richard’, ‘Hull’,’KL62′, ‘Dryer’, ‘AP’, 349.95, 4, 329.95);
INSERT INTO Order_Report VALUES
(‘21614′, ’05-FEB-20’, ‘282’, ‘Brookings Direct’, ‘book@bdirect.com’, 431.50, 10000, ’30’, ‘Richard’, ‘Hull’,’KT03′, ‘Dishwasher’, ‘AP’, 595, 2, 595);
INSERT INTO Order_Report VALUES
(‘21617′, ’06-FEB-20’, ‘608’, ‘Johnson”s Department Store’, ‘chris2@jdstore.com’, 2106, 10000, ’40’, ‘Juan’, ‘Perez’,’BV06′, ‘Home Gym’, ‘SG’, 794.95, 2, 794.95);
INSERT INTO Order_Report VALUES
(‘21617′, ’06-FEB-20’, ‘608’, ‘Johnson”s Department Store’, ‘chris2@jdstore.com’, 2106, 10000, ’40’, ‘Juan’, ‘Perez’,’CD52′, ‘Microwave Oven’, ‘AP’, 165, 4, 150);
INSERT INTO Order_Report VALUES
(‘21619′, ’06-FEB-20’, ‘148’, ‘Al”s Appliances’, ‘alsstore@net.com’, 6550, 7500, ’20’, ‘Valerie’, ‘Kaiser’, ‘AT94’, ‘Iron’, ‘HW’, 24.95, 5, 24.95);
INSERT INTO Order_Report VALUES
(‘21619′, ’06-FEB-20’, ‘148’, ‘Al”s Appliances’, ‘alsstore@net.com’, 6550, 7500, ’20’, ‘Valerie’, ‘Kaiser’, ‘DR93’, ‘Gas Range’, ‘AP’, 495, 1, 495);

commit;