--触发器
CREATE OR REPLACE TRIGGER "U_ME"."TGR_1" BEFORE
INSERT ON "TABLE_SEND" FOR EACH ROW begin
select a_seq_send.nextval into :new.index from dual;
end;--序列
CREATE SEQUENCE "U_ME"."A_SEQ_SEND" INCREMENT BY 1 START WITH 1 MAXVALUE
1.0E27 MINVALUE 1 NOCYCLE
CACHE 20 ORDER是缓冲20造成?可机器一直在正常运转
CREATE OR REPLACE TRIGGER "U_ME"."TGR_1" BEFORE
INSERT ON "TABLE_SEND" FOR EACH ROW begin
select a_seq_send.nextval into :new.index from dual;
end;--序列
CREATE SEQUENCE "U_ME"."A_SEQ_SEND" INCREMENT BY 1 START WITH 1 MAXVALUE
1.0E27 MINVALUE 1 NOCYCLE
CACHE 20 ORDER是缓冲20造成?可机器一直在正常运转
alter system flush shared_pool
就会刷新sequence的缓冲值