oracle建表语句模板

-- Create table
create table BOI_INST_ORDER
(
  code              string,
  inst_code         string,
  fund_code         string,
  strategy_code     string,
  cash_account_code string,
  trade_type        string,
  advisor_code      string,
  advisor_name      string,
  symbol            string,
  secu_code         string,
  secu_name         string,
  status            string,
  amt               decimal(15,2),
  vol               decimal(15,2),
  investment_date   decimal(13),
  remark            string,
  create_user       string,
  update_user       string,
  create_time       string,
  update_time       string,
  exec_code         string
)
tablespace TBS_COI
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table BOI_INST_ORDER
  is '委托表';
-- Add comments to the columns 
comment on column BOI_INST_ORDER.code
  is '委托编码';
comment on column BOI_INST_ORDER.inst_code
  is '指令编码';
comment on column BOI_INST_ORDER.fund_code
  is '产品编码';
comment on column BOI_INST_ORDER.strategy_code
  is '策略代码';
comment on column BOI_INST_ORDER.cash_account_code
  is '账户代码';
comment on column BOI_INST_ORDER.trade_type
  is '交易方向';
comment on column BOI_INST_ORDER.advisor_code
  is '资产受托人代码';
comment on column BOI_INST_ORDER.advisor_name
  is '资产受托人名称';
comment on column BOI_INST_ORDER.symbol
  is 'SYMBOL';
comment on column BOI_INST_ORDER.secu_code
  is '投资资产编码';
comment on column BOI_INST_ORDER.secu_name
  is '投资资产名称';
comment on column BOI_INST_ORDER.status
  is '委托状态';
comment on column BOI_INST_ORDER.amt
  is '委托金额';
comment on column BOI_INST_ORDER.vol
  is '委托份额';
comment on column BOI_INST_ORDER.investment_date
  is '投资执行日';
comment on column BOI_INST_ORDER.remark
  is '备注';
comment on column BOI_INST_ORDER.create_user
  is '创建用户';
comment on column BOI_INST_ORDER.update_user
  is '修改人';
comment on column BOI_INST_ORDER.create_time
  is '创建时间';
comment on column BOI_INST_ORDER.update_time
  is '修改时间';
comment on column BOI_INST_ORDER.exec_code
  is '成交编码';
-- Create/Recreate primary, unique and foreign key constraints 
alter table BOI_INST_ORDER
  add primary key (CODE)
  using index 
  tablespace TBS_COI
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );