create sequence AUTO_ADD --序列名 (AUTO_ADD 为系列名,随便取名)
increment by 1 --每次增加1
start with 1 --从1开始
nomaxvalue --没有最大值
nocache --没有缓存序列
CREATE or replace TRIGGER my_trigger BEFORE INSERT ON testssh FOR EACH ROW
BEGIN SELECT AUTO_ADD.NEXTVAL INTO :new.userid FROM DUAL;
END;
increment by 1 --每次增加1
start with 1 --从1开始
nomaxvalue --没有最大值
nocache --没有缓存序列
CREATE or replace TRIGGER my_trigger BEFORE INSERT ON testssh FOR EACH ROW
BEGIN SELECT AUTO_ADD.NEXTVAL INTO :new.userid FROM DUAL;
END;