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