你可以定义一个序列和一个触发器实现某各字段的自增长,下面是个实现子增长自段的例子
create sequence SEQ_LOGID
minvalue 1
maxvalue 99999999
start with 1401
increment by 1
cache 20;CREATE OR REPLACE TRIGGER TR_LOGID
BEFORE INSERT
on T028_LOG
for each rowbegin
SELECT SEQ_LOGID.NEXTVAL
INTO :new.ID
FROM dual;
end;
create sequence SEQ_LOGID
minvalue 1
maxvalue 99999999
start with 1401
increment by 1
cache 20;CREATE OR REPLACE TRIGGER TR_LOGID
BEFORE INSERT
on T028_LOG
for each rowbegin
SELECT SEQ_LOGID.NEXTVAL
INTO :new.ID
FROM dual;
end;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货