还建一“序列”,再在表中建“触发器”
:建一“序列”
CREATE SEQUENCE WEBPF.SE_M_INSERT
INCREMENT BY 1
START WITH 2701
NOMAXVALUE
NOMINVALUE
NOCYCLE
CACHE 20
ORDER
/在表TAB_PUBS(的字段PUB_ID)调用
CREATE OR REPLACE TRIGGER WEBPF.TR_PUBS
BEFORE INSERT
ON WEBPF.TAB_PUBS
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
SELECT SYS_INFOR.NEXTVAL INTO :NEW.PUB_ID FROM DUAL;
END;
/
:建一“序列”
CREATE SEQUENCE WEBPF.SE_M_INSERT
INCREMENT BY 1
START WITH 2701
NOMAXVALUE
NOMINVALUE
NOCYCLE
CACHE 20
ORDER
/在表TAB_PUBS(的字段PUB_ID)调用
CREATE OR REPLACE TRIGGER WEBPF.TR_PUBS
BEFORE INSERT
ON WEBPF.TAB_PUBS
REFERENCING OLD AS OLD NEW AS NEW
FOR EACH ROW
BEGIN
SELECT SYS_INFOR.NEXTVAL INTO :NEW.PUB_ID FROM DUAL;
END;
/
create table时IDENTITY(初植,步长)
lzf791218(lzf)的样子即可。
2、使用:
SELECT SE_M_INSERT.NEXTVAL FROM DUAL;