create table Employee
(EMPLOYEE_ID int, LAST_NAME varchar(20), FIRST_NAME varchar(30), MIDDLE_NAME varchar(20),JOB_ID int, MANAGER_ID int, HIREDATE date, SALARY int, COMM int, DEPARTMENT_ID int);
insert into Employee(EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, JOB_ID, MANAGER_ID, HIREDATE,SALARY,COMM,
DEPARTMENT_ID )
values(7369,'SMITH','JOHN','Q',667,7902,'17-DEC-84',800,NULL,20);
insert into Employee(EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, JOB_ID, MANAGER_ID, HIREDATE,SALARY,COMM,
DEPARTMENT_ID )
values(7499,'ALLEN', 'KEVIN', 'J', 670, 7698, '20-FEB-85', 1600, 300, 30);
insert into Employee(EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, JOB_ID, MANAGER_ID, HIREDATE,SALARY,COMM,
DEPARTMENT_ID )
values(7505,'DOYLE', 'JEAN', 'K', 671, 7839, '04-APR-85', 2850, NULL, 30);
insert into Employee(EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, JOB_ID, MANAGER_ID, HIREDATE,SALARY,COMM,
DEPARTMENT_ID )
values(7506,'DENNIS', 'LYNN', 'S', 671, 7839, '15-MAY-85', 2750, NULL, 30);
insert into Employee(EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, JOB_ID, MANAGER_ID, HIREDATE,SALARY,COMM,
DEPARTMENT_ID )
values(7507,'BAKER', 'LESLIE', 'D', 671, 7839, '10-JUN-85', 2200, NULL, 40);
insert into Employee(EMPLOYEE_ID, LAST_NAME, FIRST_NAME, MIDDLE_NAME, JOB_ID, MANAGER_ID, HIREDATE,SALARY,COMM,
DEPARTMENT_ID )
values(7521,'WARK', 'CYNTHIA', 'D', 670, 7698, '22-FEB-85', 1250, 500, 30);
|
EMPLOYEE |
|||||||||
|
EMPLOYEE_ID |
LAST_NAME |
FIRST_NAME |
MIDDLE_NAME |
JOB_ID |
MANAGER_ID |
HIREDATE |
SALARY |
COMM |
DEPARTMENT_ID |
|
7369 |
SMITH |
JOHN |
Q |
667 |
7902 |
17-DEC-84 |
800 |
NULL |
20 |
|
7499 |
ALLEN |
KEVIN |
J |
670 |
7698 |
20-FEB-85 |
1600 |
300 |
30 |
|
7505 |
DOYLE |
JEAN |
K |
671 |
7839 |
04-APR-85 |
2850 |
NULL |
30 |
|
7506 |
DENNIS |
LYNN |
S |
671 |
7839 |
15-MAY-85 |
2750 |
NULL |
30 |
|
7507 |
BAKER |
LESLIE |
D |
671 |
7839 |
10-JUN-85 |
2200 |
NULL |
40 |
|
7521 |
WARK |
CYNTHIA |
D |
670 |
7698 |
22-FEB-85 |
1250 |
500 |
30 |
