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