Yurttas/PL/DBL/postgres/F/01/SPJ/Projects-ins.sql
Revision as of 00:54, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Projects-ins.sql REM REM: SELECT current_schema(); SET search_path to "spj"; INSERT INTO Projects ...")
1/*
2REM
3REM
4REM Projects-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "spj";
11
12INSERT INTO Projects
13 VALUES('J01', 'Monitor', 'Boston');
14
15INSERT INTO Projects
16 VALUES('J02', 'Monitor', 'Portland');
17
18INSERT INTO Projects
19 VALUES('J03', 'Monitor', 'Denver');
20
21INSERT INTO Projects
22 VALUES('J04', 'Monitor', 'Houston');
23
24INSERT INTO Projects
25 VALUES('J05', 'Monitor', 'Dallas');
26
27INSERT INTO Projects
28 VALUES('J06', 'Monitor', 'Phoenix');
29
30INSERT INTO Projects
31 VALUES('J07', 'Monitor', 'Detroit');
32
33INSERT INTO Projects
34 VALUES('J08', 'Monitor', 'New York');
35
36INSERT INTO Projects
37 VALUES('J09', 'Monitor', 'Philadelphia');
38
39INSERT INTO Projects
40 VALUES('J10', 'CD-ROM', 'Boston');
41
42INSERT INTO Projects
43 VALUES('J11', 'CD-ROM', 'Houston');
44
45INSERT INTO Projects
46 VALUES('J12', 'CD-ROM', 'Dallas');
47
48INSERT INTO Projects
49 VALUES('J13', 'CD-ROM', 'New York');
50
51INSERT INTO Projects
52 VALUES('J14', 'CD-ROM', 'Portland');