Yurttas/PL/DBL/oracle/F/02/SPJ/Shipments-ins.sp

 1/*
 2REM
 3REM Shipments-ins.sp
 4REM
 5*/
 6
 7DECLARE
 8
 9BEGIN
10
11  INSERT INTO Shipments
12    VALUES('S01', 'P01', 'J01', 20);
13
14  INSERT INTO Shipments
15    VALUES('S01', 'P01', 'J02', 10);
16
17  INSERT INTO Shipments
18    VALUES('S01', 'P01', 'J03', 20);
19
20  INSERT INTO Shipments
21    VALUES('S01', 'P02', 'J01', 40);
22
23  INSERT INTO Shipments
24    VALUES('S01', 'P02', 'J02', 20);
25
26  INSERT INTO Shipments
27    VALUES('S01', 'P02', 'J03', 10);
28
29  INSERT INTO Shipments
30    VALUES('S01', 'P02', 'J04', 30);
31
32  INSERT INTO Shipments
33    VALUES('S01', 'P03', 'J02', 60);
34
35  INSERT INTO Shipments
36    VALUES('S01', 'P03', 'J03', 30);
37
38  INSERT INTO Shipments
39    VALUES('S01', 'P04', 'J01', 20);
40
41  INSERT INTO Shipments
42    VALUES('S02', 'P02', 'J01', 10);
43
44  INSERT INTO Shipments
45    VALUES('S02', 'P03', 'J01', 40);
46
47  INSERT INTO Shipments
48    VALUES('S02', 'P04', 'J01', 30);
49
50  INSERT INTO Shipments
51    VALUES('S02', 'P04', 'J02', 20);
52
53  INSERT INTO Shipments
54    VALUES('S02', 'P04', 'J03', 40);
55
56  INSERT INTO Shipments
57    VALUES('S03', 'P01', 'J01', 10);
58
59  INSERT INTO Shipments
60    VALUES('S03', 'P01', 'J02', 10);
61
62  INSERT INTO Shipments
63    VALUES('S03', 'P03', 'J03', 20);
64
65  INSERT INTO Shipments
66    VALUES('S03', 'P04', 'J04', 10);
67
68END;
69/