【SQL开源代码栏目提醒】:以下是网学会员为您推荐的SQL开源代码-qyxx_table.sql,希望本篇文章对您学习有所帮助。
prompt PL/SQL Developer import file
prompt Created on 2006年3月3日 by Jerry
set feedback off
set define off
prompt Creating QYXX_DEPARTMENT...
create table QYXX_DEPARTMENT
(
ID NUMBER,
DEPART_NAME VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating QYXX_GOODS...
create table QYXX_GOODS
(
ID NUMBER,
GOOD_NAME VARCHAR2(100),
GOOD_PRICE VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating QYXX_MONEY...
create table QYXX_MONEY
(
ID NUMBER,
MOUNT VARCHAR2(100),
JIEDAI VARCHAR2(100),
DEPART_ID NUMBER,
MONEY_MEN VARCHAR2(100),
MONEY_PRIORITY VARCHAR2(100),
MONEY_TIME VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating QYXX_PRODUCE...
create table QYXX_PRODUCE
(
ID NUMBER,
GOOD_ID NUMBER,
PRODUCE_MOUNT NUMBER,
PRODUCE_TIME VARCHAR2(100),
PRODUCE_MEN VARCHAR2(100),
PRIORITY VARCHAR2(100)
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating QYXX_SALES...
create table QYXX_SALES
(
ID NUMBER,
GOOD_ID NUMBER,
SALES_MOUNT VARCHAR2(100),
SALES_PRICE VARCHAR2(100),
SALES_TIME VARCHAR2(100),
SALES_MEN VARCHAR2(100),
PRIORITY VARCHAR2(100),
MONEY_ID NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating QYXX_USER...
create table QYXX_USER
(
USERNAME VARCHAR2(100),
PASSWORD VARCHAR2(100),
PRIORITY VARCHAR2(100),
NAME VARCHAR2(100),
AGE VARCHAR2(100),
SEX VARCHAR2(100),
SALARY VARCHAR2(100),
DEPART_ID NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for QYXX_DEPARTMENT...
alter table QYXX_DEPARTMENT disable all triggers;
prompt Disabling triggers for QYXX_GOODS...
alter table QYXX_GOODS disable all triggers;
prompt Disabling triggers for QYXX_MONEY...
alter table QYXX_MONEY disable all triggers;
prompt Disabling triggers for QYXX_PRODUCE...
alter table QYXX_PRODUCE disable all triggers;
prompt Disabling triggers for QYXX_SALES...
alter table QYXX_SALES disable all triggers;
prompt Disabling triggers for QYXX_USER...
alter table QYXX_USER disable all triggers;
prompt Deleting QYXX_USER...
delete from QYXX_USER;
commit;
prompt Deleting QYXX_SALES...
delete from QYXX_SALES;
commit;
prompt Deleting QYXX_PRODUCE...
delete from QYXX_PRODUCE;
commit;
prompt Deleting QYXX_MONEY...
delete from QYXX_MONEY;
commit;
prompt Deleting QYXX_GOODS...
delete from QYXX_GOODS;
commit;
prompt Deleting QYXX_DEPARTMENT...
delete from QYXX_DEPARTMENT;
commit;
prompt Loading QYXX_DEPARTMENT...
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (1, '董事会');
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (2, '生产部');
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (3, '销售部');
insert into QYXX_DEPARTMENT (ID, DEPART_NAME)
values (4, '财务部');
commit;
prompt 4 records loaded
prompt Loading QYXX_GOODS...
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (1, '木材', '100');
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (2, '橡胶', '120');
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (3, '石油', '150');
insert into QYXX_GOODS (ID, GOOD_NAME, GOOD_PRICE)
values (4, '钢铁', '180');
commit;
prompt 4 records loaded
prompt Loading QYXX_MONEY...
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (6, '2214', '1', 1, 'admin', '3', '2006-3-3 2:44:45');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (2, '1000', '2', 2, 'b', '1', '2006-3-3 1:20:47');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (7, '14300', '1', 3, 'c', '1', '2006-3-3 15:26:25');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (4, '100', '2', 1, 'admin', '3', '2006-3-3 2:10:30');
insert into QYXX_MONEY (ID, MOUNT, JIEDAI, DEPART_ID, MONEY_MEN, MONEY_PRIORITY, MONEY_TIME)
values (5, '100