[大数据]oracle实例-scott四张表（含建表及添加数据的sql代码）

SCOTT用户有四张数据表：

1. 部门信息表：dept

2. 雇员信息表：emp

3. 工资等级表：salgrade

5. 工资表：bonus

以下为手动建表及插入数据的代码

-- 1、建dept表
create table dept(
DEPTNO INT(2) NOT NULL PRIMARY KEY,
DNAME VARCHAR(14),
LOC VARCHAR(13)
);

-- 2、建emp表
CREATE TABLE emp(
EMPNO INT(4) NOT NULL PRIMARY KEY,
ENAME VARCHAR(10),
JOB VARCHAR(9),
MGR NUMERIC(4),
HIREDATE DATETIME,
SAL NUMERIC(7,2),
COMM NUMERIC(7,2),
DEPTNO INT(2)
);

-- 3、建salgrade表
CREATE TABLE salgrade (
GRADE NUMERIC,
LOSAL NUMERIC,
HISAL NUMERIC
);

-- 4、建bonus表
CREATE TABLE bonus(
ENAME VARCHAR(10),
JOB VARCHAR(9),
SAL NUMERIC,
COMM NUMERIC
);


-- 5、在dept中插入数据
INSERT INTO dept VALUES (10, 'ACCOUNTING', 'NEW YORK');
INSERT INTO dept VALUES (20, 'RESEARCH', 'DALLAS');
INSERT INTO dept VALUES (30, 'SALES', 'CHICAGO');
INSERT INTO dept VALUES (40, 'OPERATIONS', 'BOSTON');


-- 6、在emp中插入数据
INSERT INTO emp VALUES (7369, 'SMITH', 'CLERK', 7902, '1980-12-17',800,NULL,20);
INSERT INTO emp VALUES (7499, 'ALLEN', 'SALESMAN', 7698, '1981-2-20',1600,300,30);
INSERT INTO emp VALUES (7521, 'WARD', 'SALESMAN', 7698, '1981-2-22',1250,500,30);
INSERT INTO emp VALUES (7566, 'JONES', 'MANAGER', 7839, '1981-4-2',2975,NULL,20);
INSERT INTO emp VALUES (7654, 'MARTIN', 'SALESMAN', 7698, '1981-9-28',1250,1400,30);
INSERT INTO emp VALUES (7698, 'BLAKE', 'MANAGER', 7839, '1981-5-1',2850,NULL,30);
INSERT INTO emp VALUES (7782, 'CLARK', 'MANAGER', 7839, '1981-6-9',2450,NULL,10);
INSERT INTO emp VALUES (7788, 'SCOTT', 'ANALYST', 7566, '1987-4-19',3000,NULL,20);
INSERT INTO emp VALUES (7839, 'KING', 'PRESIDENT',NULL,'1981-11-17',5000,NULL,10);
INSERT INTO emp VALUES (7844, 'TURNER', 'SALESMAN', 7698, '1981-9-8',1500,0,30);
INSERT INTO emp VALUES (7876, 'ADAMS', 'CLERK', 7788, '1987-5-23',1100,NULL,20);
INSERT INTO emp VALUES (7900, 'JAMES', 'CLERK', 7698, '1981-12-3',950,NULL,30);
INSERT INTO emp VALUES (7902, 'FORD', 'ANALYST', 7566, '1981-12-3',3000,NULL,20);
INSERT INTO emp VALUES (7934, 'MILLER', 'CLERK', 7782, '1982-1-23',1300,NULL,10);

-- 7、在salgrade中插入数据
INSERT INTO salgrade VALUES (1,700,1200);
INSERT INTO salgrade VALUES (2,1201,1400);
INSERT INTO salgrade VALUES (3,1401,2000);
INSERT INTO salgrade VALUES (4,2001,3000);
INSERT INTO salgrade VALUES (5,3001,9999);

-- 8、bonus表中无数据