create or replace trigger tri_ins_tbl before insert on wux_pc_event for each row begin select SQ_EVENT_ID.nextval into :new.eq_id; end; /要注意的是SQ_EVENT_ID.currval 只有在使用了一次SQ_EVENT_ID.nextval 才有用,否则报错。
ORACLE没有这样的功能,还是重程序实现把,希望以后能实现。
CREATE SEQUENCE USERID INCREMENT BY 1 START WITH 1 MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE NOCACHE NOORDER;CREATE OR REPLACE TRIGGER USERADD BEFORE INSERT ON MEMBERRG FOR EACH ROW BEGIN SELECT LPAD(USERID.NEXTVAL,4,'0') INTO :NEW.NUM FROM DUAL; END;
before insert
on wux_pc_event
for each row
begin
select SQ_EVENT_ID.nextval into :new.eq_id;
end;
/要注意的是SQ_EVENT_ID.currval 只有在使用了一次SQ_EVENT_ID.nextval 才有用,否则报错。
MAXVALUE 1.0E28 MINVALUE 1 NOCYCLE
NOCACHE NOORDER;CREATE OR REPLACE TRIGGER USERADD
BEFORE INSERT ON MEMBERRG
FOR EACH ROW
BEGIN
SELECT LPAD(USERID.NEXTVAL,4,'0') INTO :NEW.NUM FROM DUAL;
END;