CONNECT system/manager
SET ECHO ON
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(610,'11-NOV-97','A01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(611,'15-NOV-97','A02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(612,'19-NOV-97','A04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(601,'05-MAR-97','A06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(602,'09-APR-97','A02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(600,'05-MAR-97','A03');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(604,'19-APR-97','A06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(605,'18-MAY-97','A06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(606,'18-MAY-97','C01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(609,'05-JUN-97','C01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(607,'22-MAY-97','A04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(608,'29-MAY-97','A04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(603,'09-APR-97','A02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(620,'14-JAN-98','C01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(613,'06-DEC-97','A08');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(614,'06-DEC-97','A02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(616,'08-DEC-97','A03');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(619,'27-DEC-97','A04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(617,'10-DEC-97','A05');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(615,'06-DEC-97','A07');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(618,'20-DEC-97','A02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(621,'17-JAN-98','C01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(509,'08-APR-96','B26');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(523,'18-DEC-96','B26');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(549,'31-OCT-97','B26');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(507,'30-MAR-96','B28');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(516,'04-AUG-96','B28');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(553,'07-DEC-97','B28');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(526,'06-JAN-97','B21');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(543,'09-JUL-97','B21');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(555,'06-JAN-98','B21');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(559,'20-SEP-97','B22');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(528,'26-JAN-97','B24');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(531,'02-FEB-97','B24');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(558,'02-FEB-98','B24');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(525,'02-JAN-97','B25');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(552,'07-DEC-97','B23');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(556,'12-JAN-98','B23');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(560,'27-FEB-98','B23');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(565,'05-APR-98','B27');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(574,'14-AUG-98','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(576,'17-AUG-98','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(503,'28-JAN-96','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(518,'24-AUG-96','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(517,'27-AUG-96','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(544,'16-JUL-97','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(524,'27-DEC-96','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(502,'16-DEC-95','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(539,'30-APR-97','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(511,'21-JUN-96','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(512,'02-JUL-96','B03');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(562,'08-MAR-98','B03');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(529,'04-FEB-97','B03');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(563,'29-MAR-98','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(568,'17-MAY-98','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(504,'14-FEB-96','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(538,'27-APR-97','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(535,'01-APR-97','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(578,'23-SEP-98','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(534,'15-MAR-97','B06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(536,'25-MAR-97','B06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(572,'23-JUN-98','B06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(514,'10-JUL-96','B07');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(521,'24-SEP-96','B07');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(551,'26-NOV-97','B08');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(513,'11-JUL-96','B08');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(508,'30-MAR-96','B08');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(515,'24-JUL-96','B08');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(542,'15-JUN-97','B08');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(573,'14-AUG-98','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(566,'13-APR-98','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(520,'20-SEP-96','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(519,'24-AUG-96','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(575,'08-AUG-98','B01');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(547,'20-AUG-97','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(540,'19-MAY-97','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(567,'09-MAY-98','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(570,'21-MAY-98','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(571,'06-JUN-98','B02');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(541,'12-JUN-97','B03');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(532,'10-FEB-97','B03');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(527,'01-JAN-97','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(501,'11-NOV-95','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(564,'29-MAR-98','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(537,'18-APR-97','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(522,'11-NOV-96','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(554,'23-DEC-97','B04');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(569,'20-MAY-98','B05');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(550,'01-DEC-97','B05');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(548,'30-SEP-97','B05');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(505,'10-FEB-96','B06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(577,'10-AUG-98','B06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(533,'02-MAR-97','B06');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(561,'22-FEB-98','B07');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(506,'01-MAR-96','B08');
INSERT INTO orders2(ord_id,ord_date,cust_code) VALUES(530,'05-FEB-97','B08'
OraCourseSQL_007.rar （25个子文件） 
OraCourseSQL_007 
007.rar 8KB 007 007 
lab09_01.sql 2KB lab12_05a.sql 418B lab13_07.sql 169B lab10_03.sql 95B lab11_09.sql 8KB lcase1.log 2KB lab14_01.sql 209B lcase1.ctl 699B lab02_04.sql 92B OEMsqlcase2.dat 1KB lcase2.dat 1KB lab13_03.sql 174B lcase2.ctl 240B OEMsqlcase2.ctl 192B lab09_05.sql 418B lab13_08.sql 214B OEMsqlcase1.ctl 701B lab19_01.sql 117B lab15_01.sql 32B lab11_02.sql 2KB lab13_01.sql 991B lab16_02a.sql 406B lcase2.log 2KB 常用脚本.rar 317KB
评论1