第一次ORACLE实验
ORACLE实验一(三)
DUCT VALUES('A','1002','PC');
INSERT INTO PRODUCT VALUES('A','1003','PC');
INSERT INTO PRODUCT VALUES('B','1004','PC');
INSERT INTO PRODUCT VALUES('B','1006','PC');
INSERT INTO PRODUCT VALUES('B','3002','Printer');
INSERT INTO PRODUCT VALUES('B','3004','Printer');
INSERT INTO PRODUCT VALUES('C','1005','PC');
INSERT INTO PRODUCT VALUES('C','1007','PC');
INSERT INTO PRODUCT VALUES('D','1008','PC');
INSERT INTO PRODUCT VALUES('D','1009','PC');
INSERT INTO PRODUCT VALUES('D','1010','PC');
INSERT INTO PRODUCT VALUES('D','2001','Laptop');
INSERT INTO PRODUCT VALUES('D','2002','Laptop');
INSERT INTO PRODUCT VALUES('D','2003','Laptop');
INSERT INTO PRODUCT VALUES('D','3001','Printer');
INSERT INTO PRODUCT VALUES('D','3003','Printer');
INSERT INTO PRODUCT VALUES('E','2004','Laptop');
INSERT INTO PRODUCT VALUES('E','2008','Laptop');
INSERT INTO PRODUCT VALUES('F','2005','Laptop');
INSERT INTO PRODUCT VALUES('G','2006','Laptop');
INSERT INTO PRODUCT VALUES('G','2007','Laptop');
INSERT INTO PRODUCT VALUES('H','3005','Printer');
INSERT INTO PRODUCT VALUES('I','3006','Printer');
INSERT INTO PC VALUES('1001', 122,16,1.6,'6X',1595);
INSERT INTO PC VALUES('1002', 120,16,1.6,'6X',1399);
INSERT INTO PC VALUES('1003', 166,24,2.5,'6X',1899);
INSERT INTO PC VALUES('1004', 166,32,2.5,'8X',1999);
INSERT INTO PC VALUES('1005', 166,16,2 ,'8X',1999);
INSERT INTO PC VALUES('1006', 200,32,3.1,'8X',2099);
INSERT INTO PC VALUES('1007', 200,32,3.2,'8X',2349);
INSERT INTO PC VALUES('1008', 180,32,2 ,'8X',3699);
INSERT INTO PC VALUES('1009', 200,32,2.5,'8X',2599);
INSERT INTO PC VALUES('1010', 160,16,1.2,'8X',1495);
INSERT INTO LAPTOP VALUES('2001', 100, 20, 1.1 ,9.5 ,1999);
INSERT INTO LAPTOP VALUES('2002', 117, 12, 0.75,11.3 ,2499);
INSERT INTO LAPTOP VALUES('2003', 117, 32, 1 ,10.4 ,3599);
INSERT INTO LAPTOP VALUES('2004', 133, 16, 1.1 ,11.2 ,3499);
INSERT INTO LAPTOP VALUES('2005', 133, 16, 1 ,11.3 ,2599);
INSERT INTO LAPTOP VALUES('2006', 120, 8 , 0.81,12.1 ,1999);
INSERT INTO LAPTOP VALUES('2007', 150, 16, 1.35,12.1 ,4799);
INSERT INTO LAPTOP VALUES('2008', 120, 16, 1.1 ,12.1 ,2009);
INSERT INTO PEINTER VALUES('3001','TRUE' ,'Ink-jet',275);
INSERT INTO PEINTER VALUES('3002','TRUE' ,'Ink-jet',269);
INSERT INTO PEINTER VALUES('3003','FALSE' ,'Laser' ,829);
INSERT INTO PEINTER VALUES('3004','FALSE' ,'Laser' ,879);
INSERT INTO PEINTER VALUES('3005','FALSE' ,'Ink-jet',180);
INSERT INTO PEINTER VALUES('3006','TRUE' ,'Dry' ,470);
DROP TABLE PC;
DROP TABLE LAPTOP;
DROP TABLE PEINTER;
DROP TABLE PRODUCT;