Yurttas/PL/DBL/oracle/F/01/SPJ/Shipments-ins.sql

 1REM
 2REM
 3REM Shipments-ins.sql
 4REM
 5REM
 6
 7INSERT INTO Shipments
 8  VALUES ('S01', 'P01', 'J01', 100);
 9INSERT INTO Shipments
10  VALUES ('S01', 'P01', 'J03', 200);
11INSERT INTO Shipments  
12  VALUES ('S01', 'P01', 'J04', 200);
13INSERT INTO Shipments 
14  VALUES ('S01', 'P01', 'J07', 200);
15INSERT INTO Shipments 
16  VALUES ('S01', 'P01', 'J08', 400);
17INSERT INTO Shipments
18  VALUES ('S01', 'P01', 'J09', 300);
19INSERT INTO Shipments 
20  VALUES ('S01', 'P01', 'J10', 200);
21INSERT INTO Shipments
22  VALUES ('S01', 'P02', 'J01', 200);
23INSERT INTO Shipments
24  VALUES ('S01', 'P02', 'J02', 400);
25INSERT INTO Shipments
26  VALUES ('S01', 'P03', 'J01', 200);
27INSERT INTO Shipments
28  VALUES ('S01', 'P05', 'J02', 100);
29INSERT INTO Shipments
30  VALUES ('S01', 'P06', 'J10', 100);
31INSERT INTO Shipments
32  VALUES ('S02', 'P01', 'J01', 200);
33INSERT INTO Shipments
34  VALUES ('S02', 'P01', 'J02', 200);
35INSERT INTO Shipments
36  VALUES ('S02', 'P02', 'J01', 300);
37INSERT INTO Shipments
38  VALUES ('S02', 'P04', 'J01', 500);
39INSERT INTO Shipments
40  VALUES ('S03', 'P01', 'J01', 100);
41INSERT INTO Shipments
42  VALUES ('S03', 'P02', 'J01', 100);
43INSERT INTO Shipments
44  VALUES ('S03', 'P02', 'J02', 200);
45INSERT INTO Shipments
46  VALUES ('S03', 'P02', 'J03', 200);
47INSERT INTO Shipments
48  VALUES ('S03', 'P02', 'J04', 200);
49INSERT INTO Shipments
50  VALUES ('S03', 'P02', 'J05', 200);
51INSERT INTO Shipments
52  VALUES ('S03', 'P02', 'J06', 100);
53INSERT INTO Shipments
54  VALUES ('S03', 'P02', 'J07', 200);
55INSERT INTO Shipments
56  VALUES ('S03', 'P02', 'J08', 400);
57INSERT INTO Shipments
58  VALUES ('S03', 'P02', 'J09', 300);
59INSERT INTO Shipments
60  VALUES ('S03', 'P02', 'J10', 200);
61INSERT INTO Shipments
62  VALUES ('S03', 'P02', 'J11', 200);
63INSERT INTO Shipments
64  VALUES ('S04', 'P02', 'J03', 200);
65INSERT INTO Shipments
66  VALUES ('S05', 'P01', 'J01', 200);
67INSERT INTO Shipments
68  VALUES ('S05', 'P06', 'J04', 200);
69INSERT INTO Shipments
70  VALUES ('S05', 'P07', 'J04', 200);
71INSERT INTO Shipments
72  VALUES ('S06', 'P01', 'J04', 200);
73INSERT INTO Shipments
74  VALUES ('S06', 'P01', 'J11', 200);
75INSERT INTO Shipments
76  VALUES ('S07', 'P03', 'J02', 100);