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

 1/*
 2REM
 3REM
 4REM Dependent-ins.sql
 5REM
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "companya";
11
12INSERT INTO Dependent
13  VALUES('333445555', 'Alice', 'F', '05-APR-76', 'DAUGHTER');
14
15INSERT INTO Dependent
16  VALUES('333445555', 'Theodore', 'M', '25-OCT-73', 'SON');
17
18INSERT INTO Dependent
19  VALUES('333445555', 'Joy', 'F', '03-MAY-48', 'SPOUSE');
20
21INSERT INTO Dependent
22  VALUES('987654321', 'Abner', 'M', '29-FEB-32', 'SPOUSE');
23
24INSERT INTO Dependent
25  VALUES('123456789', 'Michael', 'M', '01-JAN-78', 'SON');
26
27INSERT INTO Dependent
28  VALUES('123456789', 'Alice', 'F', '31-DEC-78', 'DAUGHTER');
29
30INSERT INTO Dependent
31  VALUES('123456789', 'Elizabeth', 'F', '05-MAY-57', 'SPOUSE');