文档库 最新最全的文档下载
当前位置:文档库 › oracle数据库经典4表

oracle数据库经典4表

prompt PL/SQL Developer import file
prompt Created on 2008年7月17日 星期四 by Administrator
set feedback off
set define off
prompt Dropping BONUS...
drop table BONUS cascade constraints;
prompt Dropping DEPT...
drop table DEPT cascade constraints;
prompt Dropping EMP...
drop table EMP cascade constraints;
prompt Dropping T_CLASS...
drop table T_CLASS cascade constraints;
prompt Dropping T_SCORE...
drop table T_SCORE cascade constraints;
prompt Dropping T_STU...
drop table T_STU cascade constraints;
prompt Dropping T_SUBJECT...
drop table T_SUBJECT cascade constraints;
prompt Creating BONUS...
create table BONUS
(
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
SAL NUMBER,
COMM NUMBER
)
;

prompt Creating DEPT...
create table DEPT
(
DEPTNO NUMBER(2) not null,
DNAME VARCHAR2(14),
LOC VARCHAR2(13)
)
;
alter table DEPT
add constraint PK_DEPT primary key (DEPTNO);

prompt Creating EMP...
create table EMP
(
EMPNO NUMBER(4) not null,
ENAME VARCHAR2(10),
JOB2 VARCHAR2(9),
MGR NUMBER(4),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2),
AA DATE
)
;
alter table EMP
add constraint PK_EMP primary key (EMPNO);

prompt Creating T_CLASS...
create table T_CLASS
(
C_ID CHAR(3),
C_NAME VARCHAR2(8)
)
;

prompt Creating T_SCORE...
create table T_SCORE
(
STU_ID CHAR(5),
SUB_ID CHAR(6),
SCORE NUMBER(6,2),
RQ DATE
)
;

prompt Creating T_STU...
create table T_STU
(
STU_ID CHAR(5),
S_NAME CHAR(6),
C_ID CHAR(3),
S_BIRTHDAY DATE,
S_SEX CHAR(1)
)
;

prompt Creating T_SUBJECT...
create table T_SUBJECT
(
SUB_ID CHAR(6),
SUB_NAME VARCHAR2(10)
)
;

prompt Disabling triggers for BONUS...
alter table BONUS disable all triggers;
prompt Disabling triggers for DEPT...
alter table DEPT disable all triggers;
prompt Disabling triggers for EMP...
alter table EMP disable all triggers;
prompt Disabling triggers for T_CLASS...
alter table T_CLASS disable all triggers;
prompt Disabling triggers for T_SCORE...
alter table T_SCORE disable all triggers;
prompt Disabling triggers for T_STU...
alter table T_STU disable all triggers;
prompt Disabling triggers for T_SUBJECT...
alter table T_SUBJECT disable all triggers;
prompt Loading BONUS...
prompt Table is empty
prompt Loading DEPT...
insert into DEPT (DEPTNO, DNAME, LOC)
values (20, 'RESEARCH', '成都');
insert into DEPT (DEPTNO, DNAME, LOC)
values (30, 'SALES', '美国');
insert into DEPT (DEPTNO, DNAME, LOC)
values (40, 'OPERATIONS', '美国');
insert into DEPT (DEPTNO, DNAME, LOC)
values (22, '本部', '成都');
commit;
prompt 4 records loaded
prompt Loading EMP...
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7369, 'SMITH', 'CLERK', 7902, to_date('17-12-1980', 'dd-mm-yyyy'), 800, null, 20, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, H

IREDATE, SAL, COMM, DEPTNO, AA)
values (7499, 'ALLEN', 'SALESMAN', 7698, to_date('20-02-1981', 'dd-mm-yyyy'), 1600, 300, 30, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7521, 'WARD', 'SALESMAN', 7698, to_date('22-02-1981', 'dd-mm-yyyy'), 1250, 500, 30, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7566, 'JONES', 'MANAGER', 7839, to_date('02-04-1981', 'dd-mm-yyyy'), 2975, null, 20, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7654, 'MARTIN', 'SALESMAN', 7698, to_date('28-09-1981', 'dd-mm-yyyy'), 1250, 1400, 30, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7698, 'BLAKE', 'MANAGER', 7839, to_date('01-05-1981', 'dd-mm-yyyy'), 2850, null, 30, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7782, 'CLARK', 'MANAGER', 7839, to_date('09-06-1981', 'dd-mm-yyyy'), 2450, null, 10, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7788, 'SCOTT', 'ANALYST', 7566, to_date('19-04-1987', 'dd-mm-yyyy'), 3000, null, 20, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7839, 'KING', 'PRESIDENT', null, to_date('17-11-1981', 'dd-mm-yyyy'), 5000, null, 10, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7844, 'TURNER', 'SALESMAN', 7698, to_date('08-09-1981', 'dd-mm-yyyy'), 1500, 0, 30, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7876, 'ADAMS', 'CLERK', 7788, to_date('23-05-1987', 'dd-mm-yyyy'), 1100, null, 20, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7900, 'JAMES', 'CLERK', 7698, to_date('03-12-1981', 'dd-mm-yyyy'), 950, null, 30, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7902, 'FORD', 'ANALYST', 7566, to_date('03-12-1981', 'dd-mm-yyyy'), 3000, null, 20, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (7934, 'MILLER', 'CLERK', 7782, to_date('23-01-1982', 'dd-mm-yyyy'), 1300, null, 10, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (2000, 'mike2', null, null, null, null, null, null, null);
insert into EMP (EMPNO, ENAME, JOB2, MGR, HIREDATE, SAL, COMM, DEPTNO, AA)
values (1000, 'mike2', null, null, null, null, null, null, null);
commit;
prompt 16 records loaded
prompt Loading T_CLASS...
insert into T_CLASS (C_ID, C_NAME)
values ('C01', '一班');
insert into T_CLASS (C_ID, C_NAME)
values ('C02', '二班');
insert into T_CLASS (C_ID, C_NAME)
values ('C03', '三班');
commit;
prompt 3 records loaded
prompt Loading T_SCORE...
insert into T_SCORE (STU_ID, SUB_ID, SCORE, RQ)
values ('S0001', 'SUB001', 90, to_date('01-01-2008', 'dd-mm-yyyy'));
insert into T_SCORE (STU_ID, SU

B_ID, SCORE, RQ)
values ('S0002', 'SUB001', 80, to_date('01-01-2008', 'dd-mm-yyyy'));
insert into T_SCORE (STU_ID, SUB_ID, SCORE, RQ)
values ('S0001', 'SUB002', 88, to_date('01-02-2008', 'dd-mm-yyyy'));
insert into T_SCORE (STU_ID, SUB_ID, SCORE, RQ)
values ('S0002', 'SUB002', 20, to_date('01-02-2008', 'dd-mm-yyyy'));
insert into T_SCORE (STU_ID, SUB_ID, SCORE, RQ)
values ('S0003', 'SUB002', 0, to_date('01-02-2008', 'dd-mm-yyyy'));
insert into T_SCORE (STU_ID, SUB_ID, SCORE, RQ)
values ('S0003', 'SUB001', 85, to_date('01-01-2008', 'dd-mm-yyyy'));
insert into T_SCORE (STU_ID, SUB_ID, SCORE, RQ)
values ('S0099', 'SUB001', 99, to_date('01-01-2008', 'dd-mm-yyyy'));
insert into T_SCORE (STU_ID, SUB_ID, SCORE, RQ)
values ('S0002', 'SUB002', 60, to_date('01-02-2008', 'dd-mm-yyyy'));
commit;
prompt 8 records loaded
prompt Loading T_STU...
insert into T_STU (STU_ID, S_NAME, C_ID, S_BIRTHDAY, S_SEX)
values ('S0001', '张三 ', 'C01', to_date('13-01-1980', 'dd-mm-yyyy'), '1');
insert into T_STU (STU_ID, S_NAME, C_ID, S_BIRTHDAY, S_SEX)
values ('S0002', '李四 ', 'C01', to_date('21-03-1989', 'dd-mm-yyyy'), '1');
insert into T_STU (STU_ID, S_NAME, C_ID, S_BIRTHDAY, S_SEX)
values ('S0003', '张三丰', 'C02', to_date('09-07-1983', 'dd-mm-yyyy'), '1');
insert into T_STU (STU_ID, S_NAME, C_ID, S_BIRTHDAY, S_SEX)
values ('S0004', '丁老四', 'C02', to_date('09-07-1983', 'dd-mm-yyyy'), '2');
insert into T_STU (STU_ID, S_NAME, C_ID, S_BIRTHDAY, S_SEX)
values ('S0005', '张大虾', 'C02', to_date('13-10-2008', 'dd-mm-yyyy'), null);
insert into T_STU (STU_ID, S_NAME, C_ID, S_BIRTHDAY, S_SEX)
values ('SSSSS', 'SS ', 'SS ', null, null);
commit;
prompt 6 records loaded
prompt Loading T_SUBJECT...
insert into T_SUBJECT (SUB_ID, SUB_NAME)
values ('SUB001', '语文');
insert into T_SUBJECT (SUB_ID, SUB_NAME)
values ('SUB002', '数学');
insert into T_SUBJECT (SUB_ID, SUB_NAME)
values ('SUB003', '体育');
commit;
prompt 3 records loaded
prompt Enabling triggers for BONUS...
alter table BONUS enable all triggers;
prompt Enabling triggers for DEPT...
alter table DEPT enable all triggers;
prompt Enabling triggers for EMP...
alter table EMP enable all triggers;
prompt Enabling triggers for T_CLASS...
alter table T_CLASS enable all triggers;
prompt Enabling triggers for T_SCORE...
alter table T_SCORE enable all triggers;
prompt Enabling triggers for T_STU...
alter table T_STU enable all triggers;
prompt Enabling triggers for T_SUBJECT...
alter table T_SUBJECT enable all triggers;
set feedback on
set define on
prompt Done.

相关文档
相关文档 最新文档