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

From ZCubes Wiki
Jump to navigation Jump to search
 1REM
 2REM
 3REM Projects-ins.sql
 4REM
 5REM
 6
 7INSERT INTO Projects
 8  VALUES ('J01', 'Monitor', 'Boston');
 9
10INSERT INTO Projects
11  VALUES ('J02', 'Monitor', 'Portland');
12
13INSERT INTO Projects
14  VALUES ('J03', 'Monitor', 'Denver');
15
16INSERT INTO Projects
17  VALUES ('J04', 'Monitor', 'Houston');
18
19INSERT INTO Projects
20  VALUES ('J05', 'Monitor', 'Dallas');
21
22INSERT INTO Projects
23  VALUES ('J06', 'Monitor', 'Phoenix');
24
25INSERT INTO Projects
26  VALUES ('J07', 'Monitor', 'Detroit');
27
28INSERT INTO Projects
29  VALUES ('J08', 'Monitor', 'New York');
30
31INSERT INTO Projects
32  VALUES ('J09', 'Monitor', 'Philadelphia');
33
34INSERT INTO Projects
35  VALUES ('J10', 'CD-ROM', 'Boston');
36
37INSERT INTO Projects
38  VALUES ('J11', 'CD-ROM', 'Houston');
39
40INSERT INTO Projects
41  VALUES ('J12', 'CD-ROM', 'Dallas');
42
43INSERT INTO Projects
44  VALUES ('J13', 'CD-ROM', 'New York');
45
46INSERT INTO Projects
47  VALUES ('J14', 'CD-ROM', 'Portland');