ORACLE建表sql

分享一下Oracle的建表语句吧

-- Create table
create table --表名
(

***                        VARCHAR2(100),

***                     NUMBER(20)
)
tablespace  ***
  pctfree 10
  initrans 20
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table
comment on table --表名
  is '';
-- Add comments to the columns
comment on column --表名.字段名
  is '';
-- Create/Recreate primary, unique and foreign key constraints
alter table --表名
  add constraint --表名_PK primary key (--主键字段名)
  using index
  tablespace ***
  pctfree 10
  initrans 20
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate indexes
create unique index --表名_U1 on 表名 (字段名1,字段名2)
  tablespace ***
  pctfree 10
  initrans 20
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
  --普通索引
  create index --表名_N1 on 表名 (字段名1,字段名2)
  tablespace ***
  pctfree 10
  initrans 20
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Create sequence
create sequence --表_CID_S
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;

-- Create sequence
create sequence --表名_S
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;

insert into mt_sys_sequence values('table_name_cid_s',1,'table_name_cid_s');
insert into mt_sys_sequence values('table_name_s',1,'table_name_s');