1.先创建序列USERID 用户序列号 -- CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE NOCACHE NOORDER2.创建触发器USERADD 会员触发器 -- CREATE OR REPLACE TRIGGER USERADD BEFORE INSERT ON MEMBERRG FOR EACH ROW new_userid number; BEGIN select nserid.nextval into new_userid from dual; :new.num=new_userid ; --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 会员触发器
--
CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
new_userid number;
BEGIN
select nserid.nextval into new_userid from dual;
:new.num=new_userid ;
--USERID.NEXTVAL INTO :NEW.NUM FROM DUAL;
END;