Yurttas/PL/DBL/oracle/F/01/SPJ/Shipments-ins.sql
Jump to navigation
Jump to search
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);