Yurttas/PL/DBL/oracle/F/01/Company-A/Employee-ins.sql

 1REM
 2REM
 3REM Employee-ins.sql
 4REM
 5REM
 6
 7INSERT INTO Employee
 8  VALUES ('John', 'B', 'Smith', '123456789', '09-JAN-55', '731 Fondren, Houston, TX', 'M', 30000, '333445555', '5');
 9
10INSERT INTO Employee
11  VALUES ('Franklin', 'T', 'Wong', '333445555', '08-DEC-45', '638 Voss, Houston, TX', 'M', 40000, '888665555', '5');
12
13INSERT INTO Employee
14  VALUES ('Alicia',   'J', 'Zelaya',  '999887777', '19-JUL-58', '3321 Castle, Spring, TX', 'F', 25000, '987654321', '4');
15
16INSERT INTO Employee
17  VALUES ('Jennifer', 'S', 'Wallace', '987654321', '20-JUN-31', '291 Berry, Bellaire, TX', 'F', 43000, '888665555', '4');
18
19INSERT INTO Employee
20  VALUES ('Ramesh', 'K', 'Narayan', '666884444', '15-SEP-52', '975 Fire Oak, Humble, TX', 'M', 38000, '333445555', '5');
21
22INSERT INTO Employee
23  VALUES ('Joyce', 'A', 'English', '453453453', '31-JUL-62', '5631 Rice, Houston, TX', 'F', 25000, '333445555', '5');
24
25INSERT INTO Employee
26  VALUES ('Ahmad', 'V', 'Jabbar', '987987987', '29-MAR-59', '980 Dallas, Houston, TX', 'M', 25000, '987654321', '4');
27
28INSERT INTO Employee
29  VALUES ('James', 'E', 'Borg', '888665555', '10-NOV-27', '450 Stone, Houston, TX', 'M', 55000, null, '1');