Yurttas/PL/DBL/oracle/F/02/PC/Product-ins.sp
Revision as of 23:29, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="text" line start="1" enclose="div"> →REM REM REM Product-ins.sql REM REM: DECLARE BEGIN INSERT INTO Product VALUES('A', '1001', 'pc'); I...")
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/