Yurttas/PL/DBL/mysql-f-2010/01/Company-A/Dependent-ins.sql
Revision as of 01:58, 4 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Dependent-ins.sql REM REM: \. set-db.sql INSERT INTO Dependent VALUES('333445555', 'Alice', 'F', ...")
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');