Yurttas/PL/DBL/postgres/F/01/SPJ/Suppliers-ins.sql
Revision as of 00:55, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Suppliers-ins.sql REM REM: SELECT current_schema(); SET search_path to "spj"; INSERT INTO Suppliers...")
1/*
2REM
3REM
4REM Suppliers-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "spj";
11
12INSERT INTO Suppliers
13 VALUES('S01', 'Frank', 20, 'Houston');
14
15INSERT INTO Suppliers
16 VALUES('S02', 'David', 20, 'Houston');
17
18INSERT INTO Suppliers
19 VALUES('S03', 'David', 30, 'Houston');
20
21INSERT INTO Suppliers
22 VALUES('S04', 'Jason', 10, 'Denver');
23
24INSERT INTO Suppliers
25 VALUES('S05', 'Richard', 30, 'Denver');
26
27 INSERT INTO Suppliers
28 VALUES('S06', 'Carlos', 20, 'Phoenix');
29
30INSERT INTO Suppliers
31 VALUES('S07', 'John', 40, 'Phoenix');
32
33INSERT INTO Suppliers
34 VALUES('S08', 'Ajay', 30, 'Detroit');