(二)Oracle数据库初学者scott用户下的表

一、建立表结构

员工表:

create table emp(
	EMPNO INT NOT NULL,
	ENAME VARCHAR(10),
	JOB VARCHAR(9),
	MGR NUMBER(4),
	HIREDATE DATE,
	SAL NUMBER(7,2),
	COMM NUMBER(7,2),
	DEPTNO NUMBER(2)
);

部门表:

create table dept(
	DEPTNO NUMBER(2),
	DNAME VARCHAR(14),
	LOC VARCHAR(13)
	
);

建立工资等级表salgrade:

create table salgrade(
	GRADE NUMBER(4),
	LOSAL NUMBER(4),
	HISAL NUMBER(4)
);

建立工资表bonus:

create table bonus(
	ENAME VARCHAR(10),
	JOB VARCHAR(9),
	SAL NUMBER,
	COMM NUMBER
);

二、插入数据

INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7369','SMITH','CLERK','7902',TO_DATE('17-DEC-1980','DD-MON-YYYY'),'800','','20');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7944','ALLEN','SALESMAN','7698',TO_DATE('20-FEB-81','DD-MON-YYYY'),'1600','300','30');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7521','WARD','SALESMAN','7698',TO_DATE('22-FEB-81','DD-MON-YYYY'),'1250','500','30');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7566','JONES','MANAGER','7839',TO_DATE('02-APR-81','DD-MON-YYYY'),'2975','','20');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7654','MARTIN','SALESMAN','7698',TO_DATE('28-SEP-81','DD-MON-YYYY'),'1250','1400','30');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7698','BLAKE','MANAGER','7839',TO_DATE('01-MAY-81','DD-MON-YYYY'),'2850','','30');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7782','CLARK','MANAGER','7839',TO_DATE('09-JUN-81','DD-MON-YYYY'),'2450','','10');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7839','KING','PRESIDENT','',TO_DATE('17-NOV-81','DD-MON-YYYY'),'5000','','10');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7844','TURNER','SALESMAN','7698',TO_DATE('08-SEP-81','DD-MON-YYYY'),'1500','0','30');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7900','JAMES','CLERK','7698',TO_DATE('03-DEC-81','DD-MON-YYYY'),'950','','30');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7902','FORD','ANALYST','7566',TO_DATE('03-DEC-81','DD-MON-YYYY'),'3000','','30');
INSERT INTO emp (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO) VALUES ('7934','MILLER','CLERK','7782',TO_DATE('23-JAN-82','DD-MON-YYYY'),'1300','','10');

INSERT INTO dept (DEPTNO,DNAME,LOC) VALUES ('30','SALES','CHICAGO');
INSERT INTO dept (DEPTNO,DNAME,LOC) VALUES ('20','RESEARCH','DAllAS');
INSERT INTO dept (DEPTNO,DNAME,LOC) VALUES ('10','ACCOUNTING','NEW YORK');
INSERT INTO dept (DEPTNO,DNAME,LOC) VALUES ('40','OPERATIONS','BOSTON');

INSERT INTO salgrade (GRADE,LOSAL,HISAL) VALUES ('1','700','1200');
INSERT INTO salgrade (GRADE,LOSAL,HISAL) VALUES ('2','1201','1400');
INSERT INTO salgrade (GRADE,LOSAL,HISAL) VALUES ('3','1401','2000');
INSERT INTO salgrade (GRADE,LOSAL,HISAL) VALUES ('4','2001','3000');
INSERT INTO salgrade (GRADE,LOSAL,HISAL) VALUES ('5','3001','9999');