Yurttas/PL/DBL/oracle/F/02/SPJ/Shipments-ins.sp
Revision as of 23:32, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="text" line start="1" enclose="div"> →REM REM Shipments-ins.sp REM: DECLARE BEGIN INSERT INTO Shipments VALUES('S01', 'P01', 'J01', 20); ...")
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/