Yurttas/PL/DBL/postgres/F/01/Company-A/Employee-ins.sql

 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');