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);