Oracle12C--此专栏的SQL所需要的建表语句(一)

--下面的这几段SQL是是，是测试本专栏涉及到的案例所使用的SQL
-- 删除数据表
DROP TABLE emp PURGE ;
DROP TABLE dept PURGE ;
DROP TABLE bonus PURGE ;
DROP TABLE salgrade PURGE ;
-- 创建数据表
CREATE TABLE dept (
	deptno	NUMBER(2) CONSTRAINT PK_DEPT PRIMARY KEY,
	dname	VARCHAR2(14) ,
	loc		VARCHAR2(13) 
) ;
CREATE TABLE emp (
	empno	NUMBER(4) CONSTRAINT PK_EMP PRIMARY KEY,
	ename	VARCHAR2(10),
	job		VARCHAR2(9),
	mgr		NUMBER(4),
	hiredate	DATE,
	sal		NUMBER(7,2),
	comm	NUMBER(7,2),
	deptno	NUMBER(2) CONSTRAINT FK_DEPTNO REFERENCES DEPT 
);
CREATE TABLE bonus (
	enamE	VARCHAR2(10)	,
	job		VARCHAR2(9)  ,
	sal		NUMBER,
	comm	NUMBER 
) ;
CREATE TABLE salgrade ( 
	grade		NUMBER,
	losal		NUMBER,
	hisal		NUMBER 
);
-- 插入测试数据 —— 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')