Yurttas/PL/DBL/postgres/F/01/Company-A/Dependent-ins.sql
Revision as of 00:40, 5 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: SELECT current_schema(); SET search_path to "companya"; INSERT INTO Depe...")
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');