oracle设置组合主键,oracle创建表、注释以及创建联合主键

insert into pmmeninf

values('060506','posm','0605','路由规则时间设置','588205.tran?operating=institution/query_routRule.jsp','1','menu');

-- 创建路由规则时间配置表create table routRuletime(

routRule

VARCHAR2(10),

RULESTARTTIME

VARCHAR2(20),

RULEENDTIME

VARCHAR2(20),

OPER

VARCHAR2(20),

OPERTIME

VARCHAR2(20),  STATUS

VARCHAR2(2)  )

COMMENT ON COLUMN routRuletime.routRule IS '路由规则编号';

COMMENT ON COLUMN routRuletime.RULESTARTTIME IS '开始时间'; COMMENT ON

COLUMN routRuletime.RULEENDTIME IS '结束时间'; COMMENT ON COLUMN

routRuletime.OPER IS '操作员';COMMENT ON COLUMN routRuletime.OPERTIME

IS '操作日期'; COMMENT ON COLUMN routRuletime.STATUS IS '状态

0是停用  1是启用';

alter table routRuletime add constraint

PK002  primary key

(routRule,RULESTARTTIME,RULEENDTIME);

建立索引：三个字段一起使用，就建立聚合索引，比单独三个索引快create index

idx_Stuname on

student(name,sex,grade);​

​