Yurttas/PL/DBL/postgres/F/01/Company-B/Works-ins.sql
Revision as of 00:44, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Works-ins.sql REM REM: SELECT current_schema(); SET search_path to "companyb"; INSERT INTO Works ...")
1/*
2REM
3REM
4REM Works-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "companyb";
11
12INSERT INTO Works
13 VALUES('Jeremy', 'First Bank Corporation', 100000);
14
15INSERT INTO Works
16 VALUES('Charles', 'First Bank Corporation', 40000);
17
18INSERT INTO Works
19 VALUES('Jamie', 'First Bank Corporation', 40000);
20
21INSERT INTO Works
22 VALUES('Casey', 'First Bank Corporation', 30000);
23
24INSERT INTO Works
25 VALUES('Thomas', 'Small Bank Corporation', 60000);
26
27INSERT INTO Works
28 VALUES('Anthony', 'Small Bank Corporation', 60000);
29
30INSERT INTO Works
31 VALUES('Benjamin', 'Small Bank Corporation', 80000);
32
33INSERT INTO Works
34 VALUES('Sara', 'Minor Bank Corporation', 50000);
35
36INSERT INTO Works
37 VALUES('David', 'Minor Bank Corporation', 40000);
38
39INSERT INTO Works
40 VALUES('Michael', 'Major Bank Corporation', 30000);
41
42INSERT INTO Works
43 VALUES('Jennifer', 'Major Bank Corporation', 90000);