wstp_table.sql

来自「JSP+oracle开发实例精粹》随书光盘」· SQL 代码 · 共 65 行

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.