oracle9i/10g中，如果数据库实例中没有scott模式，可以手工创建，方法如下：登录数据库创建scott用户为scott用户分配权限用scott用户登录www.2cto.com1、执行下列sql语句DROPTABLEEMP;DROPTABLEDE...SyntaxHigh
oracle 9i/10g中，如果
数据库实例中没有scott模式，可以手工创建，方法如下：
登录数据库
创建scott用户
为scott用户分配权限
用scott用户登录
www.2cto.com
1、执行下列sql语句
DROP TABLE EMP;
DROP TABLE DEPT;
DROP TABLE BONUS;
DROP TABLE SALGRADE;
DROP TABLE DUMMY;
CREATE TABLE EMP
(EMPNO NUMBER(4) NOT NULL,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7, 2),
COMM NUMBER(7, 2),
DEPTNO NUMBER(2));
www.2cto.com
INSERT INTO EMP VALUES
(7369, &＃39;SMITH&＃39;, &＃39;CLERK&＃39;, 7902,
TO_DATE(&＃39;17-DEC-1980&＃39;, &＃39;DD-MON-YYYY&＃39;), 800, NULL, 20);
INSERT INTO EMP VALUES
(7499, &＃39;ALLEN&＃39;, &＃39;SALESMAN&＃39;, 7698,
TO_DATE(&＃39;20-FEB-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 1600, 300, 30);
INSERT INTO EMP VALUES
(7521, &＃39;WARD&＃39;, &＃39;SALESMAN&＃39;, 7698,
TO_DATE(&＃39;22-FEB-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 1250, 500, 30);
INSERT INTO EMP VALUES
(7566, &＃39;JONES&＃39;, &＃39;MANAGER&＃39;, 7839,
TO_DATE(&＃39;2-APR-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 2975, NULL, 20);
INSERT INTO EMP VALUES
(7654, &＃39;MARTIN&＃39;, &＃39;SALESMAN&＃39;, 7698,
TO_DATE(&＃39;28-SEP-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 1250, 1400, 30);
INSERT INTO EMP VALUES
(7698, &＃39;BLAKE&＃39;, &＃39;MANAGER&＃39;, 7839,
TO_DATE(&＃39;1-MAY-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 2850, NULL, 30);
INSERT INTO EMP VALUES
(7782, &＃39;CLARK&＃39;, &＃39;MANAGER&＃39;, 7839,
TO_DATE(&＃39;9-JUN-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 2450, NULL, 10);
INSERT INTO EMP VALUES
(7788, &＃39;SCOTT&＃39;, &＃39;ANALYST&＃39;, 7566,
TO_DATE(&＃39;09-DEC-1982&＃39;, &＃39;DD-MON-YYYY&＃39;), 3000, NULL, 20);
INSERT INTO EMP VALUES www.2cto.com
(7839, &＃39;KING&＃39;, &＃39;PRESIDENT&＃39;, NULL,
TO_DATE(&＃39;17-NOV-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 5000, NULL, 10);
INSERT INTO EMP VALUES
(7844, &＃39;TURNER&＃39;, &＃39;SALESMAN&＃39;, 7698,
TO_DATE(&＃39;8-SEP-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 1500, 0, 30);
INSERT INTO EMP VALUES
(7876, &＃39;ADAMS&＃39;, &＃39;CLERK&＃39;, 7788,
TO_DATE(&＃39;12-JAN-1983&＃39;, &＃39;DD-MON-YYYY&＃39;), 1100, NULL, 20);
INSERT INTO EMP VALUES
(7900, &＃39;JAMES&＃39;, &＃39;CLERK&＃39;, 7698,
TO_DATE(&＃39;3-DEC-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 950, NULL, 30);
INSERT INTO EMP VALUES
(7902, &＃39;FORD&＃39;, &＃39;ANALYST&＃39;, 7566,
TO_DATE(&＃39;3-DEC-1981&＃39;, &＃39;DD-MON-YYYY&＃39;), 3000, NULL, 20);
INSERT INTO EMP VALUES
(7934, &＃39;MILLER&＃39;, &＃39;CLERK&＃39;, 7782,
TO_DATE(&＃39;23-JAN-1982&＃39;, &＃39;DD-MON-YYYY&＃39;), 1300, NULL, 10);
CREATE TABLE DEPT
(DEPTNO NUMBER(2),
DNAME VARCHAR2(14),
LOC VARCHAR2(13) );
www.2cto.com
INSERT INTO DEPT VALUES (10, &＃39;ACCOUNTING&＃39;, &＃39;NEW YORK&＃39;);
INSERT INTO DEPT VALUES (20, &＃39;RESEARCH&＃39;, &＃39;DALLAS&＃39;);
INSERT INTO DEPT VALUES (30, &＃39;SALES&＃39;, &＃39;CHICAGO&＃39;);
INSERT INTO DEPT VALUES (40, &＃39;OPERATIONS&＃39;, &＃39;BOSTON&＃39;);
CREATE TABLE BONUS
(ENAME VARCHAR2(10),
JOB VARCHAR2(9),
SAL NUMBER,
COMM NUMBER);
CREATE TABLE SALGRADE
(GRADE NUMBER,
LOSAL NUMBER,
HISAL NUMBER);
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);
www.2cto.com
CREATE TABLE DUMMY
(DUMMY NUMBER);
INSERT INTO DUMMY VALUES (0);
COMMIT;
这样scott用户及它下面的经典的表就创建成功了！！
作者 luolunz
京公网安备 11010802041100号