1.	create table empgj(empno number(4,0) primary key,ename varchar2(10),  
2.	job varchar2(9),mgr number(4,0),hiredate date,sal number(7,2),comm  
3.	number(7,2),deptno number(2,0));  
4.	--1  
5.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
6.	(7369,'smith','clerk',7902,to_date('1980-12-17','yyyy/mm/dd'),  
7.	800.00,'',20);  
8.	commit;  
9.	--2  
10.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
11.	(7499,'allen','salesman',7698,to_date('1981-2-20','yyyy/mm/dd'),  
12.	1600.00,'300.00',20);  
13.	commit;  
14.	--3  
15.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
16.	(7521,'ward','salesman',7698,to_date('1981-2-22','yyyy/mm/dd'),  
17.	1250.00,'500.00',30);  
18.	commit;  
19.	--4  
20.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
21.	(7566,'jones','manager',7839,to_date('1981-4-2','yyyy/mm/dd'),  
22.	2975.00,'',20);  
23.	commit;  
24.	--5  
25.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
26.	(7654,'martin','salesman',7698,to_date('1981-9-28','yyyy/mm/dd'),  
27.	1250,'1400.00',30);  
28.	commit;  
29.	--6  
30.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
31.	(7698,'blake','manager',7839,to_date('1981-5-1','yyyy/mm/dd'),  
32.	2850,'',30);  
33.	commit;  
34.	--7  
35.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
36.	(7782,'clark','manager',7839,to_date('1981-6-9','yyyy/mm/dd'),  
37.	2450,'',10);  
38.	commit;  
39.	--8  
40.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
41.	(7788,'scott','analyst',7566,to_date('1987-4-19','yyyy/mm/dd'),  
42.	3000,'',20);  
43.	commit;  
44.	--9  
45.	insert into empgj(empno,ename,job,hiredate,sal,comm,deptno) values   
46.	(7839,'king','president',to_date('1981-11-17','yyyy/mm/dd'),  
47.	5000,'',10);  
48.	commit;  
49.	--10  
50.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
51.	(7844,'turner','salesman',7698,to_date('1981-9-8','yyyy/mm/dd'),  
52.	5000,'0.00',30);  
53.	commit;  
54.	--11  
55.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
56.	(7876,'adams','clerk',7788,to_date('1987-5-23','yyyy/mm/dd'),  
57.	1100,'',20);  
58.	commit;  
59.	--12  
60.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
61.	(7900,'james','clerk',7698,to_date('1981-12-3','yyyy/mm/dd'),  
62.	950,'',30);  
63.	commit;  
64.	--13  
65.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
66.	(7902,'ford','analyst',7566,to_date('1981-12-3','yyyy/mm/dd'),  
67.	3000,'',20);  
68.	commit;  
69.	--14  
70.	insert into empgj(empno,ename,job,mgr,hiredate,sal,comm,deptno) values   
71.	(7934,'miller','clerk',7782,to_date('1982-1-23','yyyy/mm/dd'),  
72.	1300,'',10);  
73.	commit;  
74.	select empno as "员工ID",ename as "员工姓名", job as "职位",mgr as "员工管理者ID",  
75.	hiredate as "入职日期",sal as "薪资",comm as "绩效",deptno as "员工所在部门的ID"  
76.	from empgj;  
77.	  
78.	alter session set nls_da