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;
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分钟通话, 中国电信官方发货