stuinfo.sql

来自「hibernate参考」· SQL 代码 · 共 33 行

-- Create table
create table STUINFO
(
  STU_ID    VARCHAR2(20) not null,
  STU_NAME  VARCHAR2(20),
  STU_CLASS VARCHAR2(20)
)
tablespace SYSTEM
  pctfree 10
  pctused 40
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table STUINFO
  add constraint STUINFO_PRIMARY_KEY primary key (STU_ID)
  using index 
  tablespace SYSTEM
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );