为何不使用序列?
CREATE SEQUENCE GDXB_SEQ
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 20 ORDER;
CREATE OR REPLACE TRIGGER set_seq
BEFORE INSERT ON GDXB
FOR EACH ROW
DECLARE
next_no NUMBER;
BEGIN
SELECT GDXB_SEQ.NEXTVAL
INTO next_no
FROM dual;
:new.BH := next_no;
END;
CREATE SEQUENCE GDXB_SEQ
INCREMENT BY 1
START WITH 1
NOMAXVALUE
NOCYCLE
CACHE 20 ORDER;
CREATE OR REPLACE TRIGGER set_seq
BEFORE INSERT ON GDXB
FOR EACH ROW
DECLARE
next_no NUMBER;
BEGIN
SELECT GDXB_SEQ.NEXTVAL
INTO next_no
FROM dual;
:new.BH := next_no;
END;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货