Yurttas/PL/DBL/mysql/F/01/00/Company-A/Employee-ins.sql
Revision as of 16:15, 3 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM REM Employee-ins.sql REM REM: \. set-db.sql INSERT INTO Employee VALUES('John', 'B', 'Smith', '123456...")
1/*
2REM
3REM
4REM Employee-ins.sql
5REM
6REM
7*/
8
9\. set-db.sql
10
11INSERT INTO Employee
12 VALUES('John', 'B', 'Smith', '123456789', '09-JAN-55', '731 Fondren, Houston, TX', 'M', 30000, '333445555', '5');
13
14INSERT INTO Employee
15 VALUES('Franklin', 'T', 'Wong', '333445555', '08-DEC-45', '638 Voss, Houston, TX', 'M', 40000, '888665555', '5');
16
17INSERT INTO Employee
18 VALUES('Alicia', 'J', 'Zelaya', '999887777', '19-JUL-58', '3321 Castle, Spring, TX', 'F', 25000, '987654321', '4');
19
20INSERT INTO Employee
21 VALUES('Jennifer', 'S', 'Wallace', '987654321', '20-JUN-31', '291 Berry, Bellaire, TX', 'F', 43000, '888665555', '4');
22
23INSERT INTO Employee
24 VALUES('Ramesh', 'K', 'Narayan', '666884444', '15-SEP-52', '975 Fire Oak, Humble, TX', 'M', 38000, '333445555', '5');
25
26INSERT INTO Employee
27 VALUES('Joyce', 'A', 'English', '453453453', '31-JUL-62', '5631 Rice, Houston, TX', 'F', 25000, '333445555', '5');
28
29INSERT INTO Employee
30 VALUES('Ahmad', 'V', 'Jabbar', '987987987', '29-MAR-59', '980 Dallas, Houston, TX', 'M', 25000, '987654321', '4');
31
32INSERT INTO Employee
33 VALUES('James', 'E', 'Borg', '888665555', '10-NOV-27', '450 Stone, Houston, TX', 'M', 55000, null, '1');