CREATE SEQUENCE ABC START WITH 1 INCREMENT BY 1 MAXVALUE 1E20;INSERT INTO TEST(ID,...)VALUES(ABC.NEXTVAL,...);
可以用after insert trigger试一试
CREATE SEQUENCE ID_SEQ START WITH 1 INCREMENT BY 1 MAXVALUE 999999;CREATE OR REPLACE TRIGGER GenerateID BEFORE INSERT ON tablename FOR EACH ROW BEGIN SELECT ID_SEQ.NEXTVAL INTO :NEW.ID FROM DUAL; END GenerateID;
BEFORE INSERT ON tablename
FOR EACH ROW
BEGIN
SELECT ID_SEQ.NEXTVAL
INTO :NEW.ID
FROM DUAL;
END GenerateID;