1.先创建序列
USERID 用户序列号
--
CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
NOCACHE NOORDER
2.创建触发器
USERADD 会员触发器
--
CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
USERID.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;
USERID 用户序列号
--
CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
NOCACHE NOORDER
2.创建触发器
USERADD 会员触发器
--
CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
USERID.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;