Yurttas/PL/DBL/oracle/F/01/PC/Product-ins.sql

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