Yurttas/PL/DBL/oracle/F/02/PC/Product-ins.sp

 1/*
 2REM
 3REM
 4REM Product-ins.sql
 5REM
 6REM
 7*/
 8
 9DECLARE
10
11BEGIN
12
13  INSERT INTO Product
14    VALUES('A', '1001', 'pc');
15
16  INSERT INTO Product
17    VALUES('A', '1002', 'pc');
18
19  INSERT INTO Product
20    VALUES('A', '1003', 'pc');
21
22  INSERT INTO Product
23    VALUES('B', '1004', 'pc');
24
25  INSERT INTO Product
26    VALUES('B', '1006', 'pc');
27
28  INSERT INTO Product
29    VALUES('B', '3002', 'printer');
30
31  INSERT INTO Product
32    VALUES('B', '3004', 'printer');
33
34  INSERT INTO Product
35    VALUES('C', '1005', 'pc');
36
37  INSERT INTO Product
38    VALUES('C', '1007', 'pc');
39
40  INSERT INTO Product
41    VALUES('D', '1008', 'pc');
42
43  INSERT INTO Product
44    VALUES('D', '1009', 'pc');
45
46  INSERT INTO Product
47    VALUES('D', '1010', 'pc');
48
49  INSERT INTO Product
50    VALUES('D', '2001', 'laptop');
51
52  INSERT INTO Product
53    VALUES('D', '2002', 'laptop');
54
55  INSERT INTO Product
56    VALUES('D', '2003', 'laptop');
57
58  INSERT INTO Product
59    VALUES('D', '3001', 'printer');
60
61  INSERT INTO Product
62    VALUES('D', '3003', 'printer');
63
64  INSERT INTO Product
65    VALUES('E', '2004', 'laptop');
66
67  INSERT INTO Product
68    VALUES('E', '2008', 'laptop');
69
70  INSERT INTO Product
71    VALUES('F', '2005', 'laptop');
72
73  INSERT INTO Product
74    VALUES('G', '2006', 'laptop');
75
76  INSERT INTO Product
77    VALUES('G', '2007', 'laptop');
78
79  INSERT INTO Product
80    VALUES('H', '3005', 'printer');
81
82  INSERT INTO Product
83    VALUES('I', '3006', 'printer');
84
85END;
86/