做insert 操作時(shí)不要在寫(xiě)zseq_userinfo_userid.NEXTVAL 了 和sql2005 一樣 序列會(huì)自動(dòng)增長(zhǎng)
CREATE SEQUENCE zseq_userinfo_userid;
create or replace
TRIGGER ztrg_userinfo_userid BEFORE
INSERT ON userinfo
FOR EACH ROW
WHEN (NEW.userid IS NULL) BEGIN
SELECT zseq_userinfo_userid.NEXTVAL into:new.userid FROM DUAL;
END;