mysql怎么跑代码_为什么这个代码用mySQL跑不起来

该楼层疑似违规已被系统折叠 隐藏此楼查看此楼

--------------------------------------------

-- Export file for user SCOTT --

-- Created by ttc on 2009-12-16, 13:31:38 --

--------------------------------------------

spool group1.log

prompt

prompt Creating table CODE

prompt ===================

prompt

create table CODE

(

ID NUMBER(5) not null,

TYPE_ID NUMBER(5),

CODE_NAME VARCHAR2(20),

CODE_VALUE VARCHAR2(20)

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

alter table CODE

add constraint CODE_ID_PK primary key (ID)

using index

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating table DEPT

prompt ===================

prompt

create table DEPT

(

ID NUMBER(5) not null,

DEPT_NUMBER NUMBER(5) not null,

DEPT_NAME VARCHAR2(20) not null,

DEPT_TYPE NUMBER(5) not null,

DEPT_TEL VARCHAR2(20) not null,

DEPT_FAX VARCHAR2(20),

DEPT_SUPER NUMBER(5),

DEPT_DESC VARCHAR2(50),

DEPT_SETDATE DATE not null,

SITUATION NUMBER(2) default 1 not null

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

alter table DEPT

add constraint DEPT_ID_PK primary key (ID)

using index

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating table DEPT_CHANGE

prompt ==========================

prompt

create table DEPT_CHANGE

(

ID NUMBER(5) not null,

EM_ID NUMBER(5),

DEPT_BEFORE NUMBER(5),

DEPT_AFTER NUMBER(5),

DEPT_CHTYPE NUMBER(5) not null,

DEPT_CHREASON VARCHAR2(20) not null,

DEPT_CHDATE DATE not null,

DEPT_CHEXTRA VARCHAR2(50)

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

alter table DEPT_CHANGE

add constraint DEPTC_ID_PK primary key (ID)

using index

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating table DOMISSION

prompt ========================

prompt

create table DOMISSION

(

ID NUMBER(5) not null,

LZ_TYPE NUMBER(20),

LZ_DATE DATE not null,

LZ_EXTRA VARCHAR2(20) not null,

LZ_GO VARCHAR2(20) not null

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

alter table DOMISSION

add constraint DOMISSION_ID_PK primary key (ID)

using index

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating table EMPLOYEE

prompt =======================

prompt

create table EMPLOYEE

(

ID NUMBER(5),

EM_NUMBER NUMBER(5) not null,

EM_NAME VARCHAR2(20) not null,

EM_BIRTH DATE not null,

SEX NUMBER(5) not null,

EM_FORMAT NUMBER(5) not null,

EM_SOURCE NUMBER(5) not null,

EM_POLITY NUMBER(5) not null,

EM_FOLK NUMBER(5) not null,

EM_ID VARCHAR2(20) not null,

EM_INDATE DATE not null,

EM_WORKTIME DATE not null,

EM_BIRTHPLACE VARCHAR2(20),

EM_PHONE VARCHAR2(20),

EM_MAIL VARCHAR2(20),

EM_BLOOD NUMBER(5),

EM_WEDLOCK NUMBER(5),

EM_STATURE VARCHAR2(20),

DEPT_NUMBER NUMBER(20),

JOB_NUMBER NUMBER(20),

EM_SEAT VARCHAR2(20),

EM_LEARN NUMBER(5),

EM_DEGREE NUMBER(5),

EM_GRADUATE VARCHAR2(20),

EM_SPECIALTY VARCHAR2(20),

EM_GRADATE DATE,

EM_HOMEPLACE VARCHAR2(20),

SITUATION NUMBER(2) default 1 not null

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating table JOB

prompt ==================

prompt

create table JOB

(

ID NUMBER(5) not null,

JOB_NUMBER NUMBER(5) not null,

JOB_NAME VARCHAR2(20) not null,

JOB_TYPE VARCHAR2(20) not null,

JOB_MAX NUMBER(5),

JOB_MAN NUMBER(5) default 0,

SITUATION NUMBER(2) default 1

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

alter table JOB

add constraint JOB_ID_PK primary key (ID)

using index

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating table JOB_CH

prompt =====================

prompt

create table JOB_CH

(

EMP_NUMBER NUMBER(5) not null,

EMP_NAME VARCHAR2(20) not null,

JOB_CHNAME VARCHAR2(20) not null,

JOB_CHREASON VARCHAR2(20),

JOB_CHTYPE VARCHAR2(20),

JOB_CHDATE DATE not null,

JOB_CHEXTRA VARCHAR2(20)

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating table PROBATION

prompt ========================

prompt

create table PROBATION

(

ID NUMBER(5) not null,

EM_ID NUMBER(5),

PROB_REVIEWS VARCHAR2(50),

PROB_RESULTS VARCHAR2(20),

PROB_DATA DATE,

PROB_NOTES VARCHAR2(50),

PROB_START DATE not null,

PROB_END DATE not null

)

tablespace USERS

pctfree 10

initrans 1

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

alter table PROBATION

add constraint PROBATION_ID_PK primary key (ID)

using index

tablespace USERS

pctfree 10

initrans 2

maxtrans 255

storage

(

initial 64K

minextents 1

maxextents unlimited

);

prompt

prompt Creating sequence DEPTCHANGEID

prompt ==============================

prompt

create sequence DEPTCHANGEID

minvalue 1

maxvalue 999999999999999999999999999

start with 4

increment by 1

nocache;

prompt

prompt Creating sequence DEPTID

prompt ========================

prompt

create sequence DEPTID

minvalue 1

maxvalue 999999999999999999999999999

start with 8

increment by 1

nocache;

prompt

prompt Creating sequence EMPID

prompt =======================

prompt

create sequence EMPID

minvalue 1

maxvalue 99999999999999999999

start with 19

increment by 1

nocache;

prompt

prompt Creating sequence JOB_ID

prompt ========================

prompt

create sequence JOB_ID

minvalue 1

maxvalue 999999999999999999999999999

start with 28

increment by 1

nocache;

prompt

prompt Creating sequence PROBID

prompt ========================

prompt

create sequence PROBID

minvalue 1

maxvalue 999999999999999999999999999

start with 21

increment by 1

nocache;

spool off