Yurttas/PL/DBL/oracle/F/01/SPJ/Parts-ins.sql

 1REM
 2REM
 3REM Parts-ins.sql
 4REM
 5REM
 6
 7INSERT INTO Parts
 8  VALUES ('P01', 'Nut', 'Red', 12, 'Houston');
 9
10INSERT INTO Parts
11  VALUES ('P02', 'Nut', 'Blue', 18, 'Phoenix');
12
13INSERT INTO Parts
14  VALUES ('P03', 'Cam', 'Blue', 22, 'Phoenix');
15
16INSERT INTO Parts
17  VALUES ('P04', 'Cam', 'Red', 45, 'Atlanta');
18
19INSERT INTO Parts
20  VALUES ('P05', 'Cam', 'Red', 18, 'Phoenix');
21
22INSERT INTO Parts
23  VALUES ('P06', 'Cam', 'Yellow', 19, 'Phoenix');
24
25INSERT INTO Parts
26  VALUES ('P07', 'Cog', 'Red', 59, 'Houston');
27
28INSERT INTO Parts
29  VALUES ('P08', 'Cog', 'Red', 46, 'Houston');
30
31INSERT INTO Parts
32  VALUES ('P09', 'Nut', 'Red', 22, 'Phoenix');
33
34INSERT INTO Parts
35  VALUES ('P10', 'Nut', 'Yellow', 59, 'Houston');
36
37INSERT INTO Parts
38  VALUES ('P11', 'Cam', 'Blue', 17, 'Atlanta');
39
40INSERT INTO Parts
41  VALUES ('P12', 'Cog', 'Blue', 24, 'Atlanta');