Yurttas/PL/DBL/postgres/F/01/Company-A/Employee-ins.sql
Revision as of 00:41, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Employee-ins.sql REM REM: SELECT current_schema(); SET search_path to "companya"; INSERT INTO Emplo...")
1/*
2REM
3REM
4REM Employee-ins.sql
5REM
6REM
7*/
8
9SELECT current_schema();
10SET search_path to "companya";
11
12INSERT INTO Employee
13 VALUES('John', 'B', 'Smith', '123456789', '09-JAN-55', '731 Fondren, Houston, TX', 'M', 30000, '333445555', '5');
14
15INSERT INTO Employee
16 VALUES('Franklin', 'T', 'Wong', '333445555', '08-DEC-45', '638 Voss, Houston, TX', 'M', 40000, '888665555', '5');
17
18INSERT INTO Employee
19 VALUES('Alicia', 'J', 'Zelaya', '999887777', '19-JUL-58', '3321 Castle, Spring, TX', 'F', 25000, '987654321', '4');
20
21INSERT INTO Employee
22 VALUES('Jennifer', 'S', 'Wallace', '987654321', '20-JUN-31', '291 Berry, Bellaire, TX', 'F', 43000, '888665555', '4');
23
24INSERT INTO Employee
25 VALUES('Ramesh', 'K', 'Narayan', '666884444', '15-SEP-52', '975 Fire Oak, Humble, TX', 'M', 38000, '333445555', '5');
26
27INSERT INTO Employee
28 VALUES('Joyce', 'A', 'English', '453453453', '31-JUL-62', '5631 Rice, Houston, TX', 'F', 25000, '333445555', '5');
29
30INSERT INTO Employee
31 VALUES('Ahmad', 'V', 'Jabbar', '987987987', '29-MAR-59', '980 Dallas, Houston, TX', 'M', 25000, '987654321', '4');
32
33INSERT INTO Employee
34 VALUES('James', 'E', 'Borg', '888665555', '10-NOV-27', '450 Stone, Houston, TX', 'M', 55000, null, '1');