Yurttas/PL/DBL/mysql-f-2010/01/Company-A/Dependent-ins.sql

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