做insert 操作時不要在寫zseq_userinfo_userid.NEXTVAL 了 和sql2005 一樣 序列會自動增長
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;