Oracle Scott命名下的建表语句

我们在学习Oracle时，常常要用到数据进行测试，那么建表和数据就成了必要的了。create table EMP
（
EMPNO NUMBER（4） PRIMARY KEY,
ENAME VARCHAR2（10）,
JOB VARCHAR2（9）,
MGR NUMBER（4）,
HIREDATE DATE,
SAL NUMBER（7,2）,
COMM NUMBER（7,2）,
DEPNO NUMBER（4）
）;CREATE TABLE Depth（
DEPTNO NUMBER（4）,
DNAME VARCHAR2（14）,
LOC VARCHAR2（13）
）;
CREATE TABLE Salgrade
（
GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER
）;
CREATE TABLE Bonus
（
ENAME VARCHAR（10）,
JOB VARCHAR2（9）,
SAL NUMBER,
COMM NUMBER
）;INSERT INTO Depth VALUES （10,"ACCOUNTING","NEW YORK"）;
INSERT INTO Depth VALUES （20,"RESEARCH","DALLAS"）;
INSERT INTO Depth VALUES （30,"SALES","CHICAGO"）;
INSERT INTO Depth VALUES （40,"OPERATIONS","BOSTON"）;SELECT * FROM DEPTH;INSERT INTO EMP VALUES
（7369,"SMITH","CLERK",7902,to_date（"17-12-1980","dd-mm-yyyy"）,800,null,20）;
INSERT INTO EMP VALUES
（7499,"ALLEN","SALESMAN",7698,to_date（"20-2-1981","dd-mm-yyyy"）,1600,300,30）;
INSERT INTO EMP VALUES
（7521,"WARD","SALESMAN",7698,to_date（"22-2-1981","dd-mm-yyyy"）,1250,500,30）;
INSERT INTO EMP VALUES
（7566,"JONES","MANAGER",7839,to_date（"2-4-1981","dd-mm-yyyy"）,2975,NULL,20）;
INSERT INTO EMP VALUES
（7654,"MARTIN","SALESMAN",7698,to_date（"28-9-1981","dd-mm-yyyy"）,1250,1400,30）;
INSERT INTO EMP VALUES
（7698,"BLAKE","MANAGER",7839,to_date（"1-5-1981","dd-mm-yyyy"）,2850,NULL,30）;
INSERT INTO EMP VALUES
（7782,"CLARK","MANAGER",7839,to_date（"9-6-1981","dd-mm-yyyy"）,2450,NULL,10）;
INSERT INTO EMP VALUES
（7839,"KING","PRESIDENT",NULL,to_date（"17-11-1981","dd-mm-yyyy"）,5000,NULL,10）;
INSERT INTO EMP VALUES
（7844,"TURNER","SALESMAN",7698,to_date（"8-9-1981","dd-mm-yyyy"）,1500,0,30）;
INSERT INTO EMP VALUES
（7900,"JAMES","CLERK",7698,to_date（"3-12-1981","dd-mm-yyyy"）,950,NULL,30）;
INSERT INTO EMP VALUES
（7902,"FORD","ANALYST",7566,to_date（"3-12-1981","dd-mm-yyyy"）,3000,NULL,20）;
INSERT INTO EMP VALUES
（7934,"MILLER","CLERK",7782,to_date（"23-1-1982","dd-mm-yyyy"）,1300,NULL,10）;select * from empINSERT 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）;select * from salgrade更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址