【SQL开源代码栏目提醒】:本文主要为网学会员提供wstp_table.sql,希望对需要wstp_table.sql网友有所帮助,学习一下!
prompt PL/SQL Developer import file
prompt Created on 2006年2月24日 by Jerry
set feedback off
set define off
prompt Creating WSTP_LANMU...
create table WSTP_LANMU
(
ID NUMBER,
TOPIC VARCHAR2(200),
CHOICE NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Creating WSTP_XUANZE...
create table WSTP_XUANZE
(
ID NUMBER,
CHOICE VARCHAR2(200),
CHOICE_NUM NUMBER default 0 not null,
TOPIC_ID NUMBER
)
tablespace SYSTEM
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
prompt Disabling triggers for WSTP_LANMU...
alter table WSTP_LANMU disable all triggers;
prompt Disabling triggers for WSTP_XUANZE...
alter table WSTP_XUANZE disable all triggers;
prompt Deleting WSTP_XUANZE...
delete from WSTP_XUANZE;
commit;
prompt Deleting WSTP_LANMU...
delete from WSTP_LANMU;
commit;
prompt Loading WSTP_LANMU...
prompt Table is empty
prompt Loading WSTP_XUANZE...
prompt Table is empty
prompt Enabling triggers for WSTP_LANMU...
alter table WSTP_LANMU enable all triggers;
prompt Enabling triggers for WSTP_XUANZE...
alter table WSTP_XUANZE enable all triggers;
set feedback on
set define on
prompt Done.