表结构

EMP 雇员表

编号

列名

数据类型

说明

约束

1

EMPNO

NUMBER(4,0)

雇员编号

Primary Key

2

ENAME

VARCHAR2(10 BYTE)

雇员名称


3

JOB

VARCHAR2(9 BYTE)

雇员工作


4

MGR

NUMBER(4,0)

上级领导编号


5

HIREDATE

DATE

入职日期


6

SAL

NUMBER(7,2)

雇员工资


7

COMM

NUMBER(7,2)

雇员奖金


8

DEPTNO

NUMBER(2,0)

部门编号

Foreign Key

DEPT部门表

编号

列名

数据类型

说明

约束

1

DEPTNO

NUMBER(2,0)

部门编号

Primary Key

2

DNAME

VARCHAR2(14 BYTE)

部门名称


3

LOC

VARCHAR2(13 BYTE)

部门位置


BONUS奖金表

编号

列名

数据类型

说明

约束

1

ENAME

VARCHAR2(10 BYTE)

雇员名称


2

JOB

VARCHAR2(9 BYTE)

雇员工作


3

SAL

NUMBER

雇员工资


4

COMM

NUMBER

雇员奖金


SALGRADE工资等级表

编号

列名

数据类型

说明

约束

1

GRADE

NUMBER

工资等级

Primary Key

2

LOSAL

NUMBER

最低工资


3

HISAL

NUMBER

最高工资


初始化数据

EMP 雇员表

编号

EMPNO

ENAME

JOB

MGR

HIREDATE

SAL

COMM

DEPTNO

1

7369

SMITH

CLERK

7902

17-DEC-80

800


20

2

7499

ALLEN

SALESMAN

7698

20-FEB-81

1600

300

30

3

7521

WARD

SALESMAN

7698

22-FEB-81

1250

500

30

4

7566

JONES

MANAGER

7839

02-APR-81

2975


20

5

7654

MARTIN

SALESMAN

7698

28-SEP-81

1250

1400

30

6

7698

BLAKE

MANAGER

7839

01-MAY-81

2850


30

7

7782

CLARK

MANAGER

7839

09-JUN-81

2450


10

8

7788

SCOTT

ANALYST

7566

19-APR-87

3000


20

9

7839

KING

PRESIDENT


17-NOV-81

5000


10

10

7844

TURNER

SALESMAN

7698

08-SEP-81

1500

30

11

7876

ADAMS

CLERK

7788

23-MAY-87

1100


20

12

7900

JAMES

CLERK

7698

03-DEC-81

950


30

13

7902

FORD

ANALYST

7566

03-DEC-81

3000


20

14

7934

MILLER

CLERK

7782

23-JAN-82

1300


10

DEPT部门表

编号

DEPTNO

DNAME

LOC

1

10

ACCOUNTING

NEW YORK

2

20

RESEARCH

DALLAS

3

30

SALES

CHICAGO

4

40

OPERATIONS

BOSTON

BONUS奖金表【注：该表中无初始数据】

SALGRADE工资等级表

编号

GRADE

LOSAL

HISAL

1

1

700

1200

2

2

1201

1400

3

3

1401

2000

4

4

2001

3000

5

5

3001

9999

初始化语句

查找初始化脚本，发现scott用户的初始化脚本为?/rdbms/admin/utlsampl.sql

[oracle@prodadmin]$grep-rn"CREATETABLESALGRADE"$ORACLE_HOME/u01/app/oracle/product/11.2.0/db_1/rdbms/admin/utlsampl.sql:92:CREATETABLESALGRADEgrep:/u01/app/oracle/product/11.2.0/db_1/bin/nmo:Permissiondeniedgrep:/u01/app/oracle/product/11.2.0/db_1/bin/nmhs:Permissiondeniedgrep:/u01/app/oracle/product/11.2.0/db_1/bin/nmb:Permissiondenied

初始化脚本内容展示：

RemCopyright(c)1990,2006,Oracle.Allrightsreserved.RemNAMEREMUTLSAMPL.SQLRemFUNCTIONRemNOTESRemMODIFIEDRemlburgess04/02/06-lowercasepasswordsRemmenash02/21/01-removeunnecessaryusersforsecurityreasonsRemgwood03/23/99-makealldatesY2KcompliantRemjbellemo02/27/97-dontconnectassystemRemakolk08/06/96-bug368261:AddingdateformatsRemglumpkin10/21/92-RenamedfromSQLBLD.SQLRemblinden07/27/92-AddedprimaryandforeignkeystoEMPandDEPTRemrlim04/29/91-changechartovarchar2Remmmoore04/08/91-useunlimitedtablespaceprivRempritto04/04/91-changeSYSDATEto13-JUL-87RemMendels12/07/90-bug30123;addto_datecallssolanguageindependentRemremrem$Header:utlsampl.sql02-apr-2006.21:13:01lburgessExp$sqlbld.sqlremSETTERMOUTOFFSETECHOOFFremCONGDONInvokedinRDBMSatbuildtime.29-DEC-1988remOATES:Created:16-Feb-83DROPUSERSCOTTCASCADE;DROPUSERADAMSCASCADE;DROPUSERJONESCASCADE;DROPUSERCLARKCASCADE;DROPUSERBLAKECASCADE;GRANTCONNECT,RESOURCE,UNLIMITEDTABLESPACETOSCOTTIDENTIFIEDBYtiger;DROPPUBLICSYNONYMPARTS;CONNECTSCOTT/tigerCREATETABLEDEPT(DEPTNONUMBER(2)CONSTRAINTPK_DEPTPRIMARYKEY,DNAMEVARCHAR2(14),LOCVARCHAR2(13));CREATETABLEEMP(EMPNONUMBER(4)CONSTRAINTPK_EMPPRIMARYKEY,ENAMEVARCHAR2(10),JOBVARCHAR2(9),MGRNUMBER(4),HIREDATEDATE,SALNUMBER(7,2),COMMNUMBER(7,2),DEPTNONUMBER(2)CONSTRAINTFK_DEPTNOREFERENCESDEPT);INSERTINTODEPTVALUES(10,'ACCOUNTING','NEWYORK');INSERTINTODEPTVALUES(20,'RESEARCH','DALLAS');INSERTINTODEPTVALUES(30,'SALES','CHICAGO');INSERTINTODEPTVALUES(40,'OPERATIONS','BOSTON');INSERTINTOEMPVALUES(7369,'SMITH','CLERK',7902,to_date('17-12-1980','dd-mm-yyyy'),800,NULL,20);INSERTINTOEMPVALUES(7499,'ALLEN','SALESMAN',7698,to_date('20-2-1981','dd-mm-yyyy'),1600,300,30);INSERTINTOEMPVALUES(7521,'WARD','SALESMAN',7698,to_date('22-2-1981','dd-mm-yyyy'),1250,500,30);INSERTINTOEMPVALUES(7566,'JONES','MANAGER',7839,to_date('2-4-1981','dd-mm-yyyy'),2975,NULL,20);INSERTINTOEMPVALUES(7654,'MARTIN','SALESMAN',7698,to_date('28-9-1981','dd-mm-yyyy'),1250,1400,30);INSERTINTOEMPVALUES(7698,'BLAKE','MANAGER',7839,to_date('1-5-1981','dd-mm-yyyy'),2850,NULL,30);INSERTINTOEMPVALUES(7782,'CLARK','MANAGER',7839,to_date('9-6-1981','dd-mm-yyyy'),2450,NULL,10);INSERTINTOEMPVALUES(7788,'SCOTT','ANALYST',7566,to_date('13-JUL-87','dd-mm-rr')-85,3000,NULL,20);INSERTINTOEMPVALUES(7839,'KING','PRESIDENT',NULL,to_date('17-11-1981','dd-mm-yyyy'),5000,NULL,10);INSERTINTOEMPVALUES(7844,'TURNER','SALESMAN',7698,to_date('8-9-1981','dd-mm-yyyy'),1500,0,30);INSERTINTOEMPVALUES(7876,'ADAMS','CLERK',7788,to_date('13-JUL-87','dd-mm-rr')-51,1100,NULL,20);INSERTINTOEMPVALUES(7900,'JAMES','CLERK',7698,to_date('3-12-1981','dd-mm-yyyy'),950,NULL,30);INSERTINTOEMPVALUES(7902,'FORD','ANALYST',7566,to_date('3-12-1981','dd-mm-yyyy'),3000,NULL,20);INSERTINTOEMPVALUES(7934,'MILLER','CLERK',7782,to_date('23-1-1982','dd-mm-yyyy'),1300,NULL,10);CREATETABLEBONUS(ENAMEVARCHAR2(10),JOBVARCHAR2(9),SALNUMBER,COMMNUMBER);CREATETABLESALGRADE(GRADENUMBER,LOSALNUMBER,HISALNUMBER);INSERTINTOSALGRADEVALUES(1,700,1200);INSERTINTOSALGRADEVALUES(2,1201,1400);INSERTINTOSALGRADEVALUES(3,1401,2000);INSERTINTOSALGRADEVALUES(4,2001,3000);INSERTINTOSALGRADEVALUES(5,3001,9999);COMMIT;EXIT


各位技术爱好者可以在scott用户下进行破坏性操作等，事后借助初始化脚本重新恢复。