转自http://gocom.primeton.com/blog/index.php?op=ViewArticle&articleId=54&blogId=9
/*==============================================================*/
/* 设置自增序列: 年度作业计划执行对象表 */
/*==============================================================*/
DROP SEQUENCE SEQ_TBL_Y_PLAN_ACT_OBJ;
CREATE SEQUENCE SEQ_TBL_Y_PLAN_ACT_OBJ INCREMENT BY 1 START WITH 1 MAXVALUE 9999999999 CYCLE NOCACHE;
CREATE OR REPLACE TRIGGER TRG_TBL_Y_PLAN_ACT_OBJ
BEFORE INSERT ON TBL_Y_PLAN_ACT_OBJ
FOR EACH ROW
BEGIN
SELECT SEQ_TBL_Y_PLAN_ACT_OBJ.NEXTVAL INTO :NEW.OBJ_ID FROM DUAL;
END;
这是通用的格式,
TBL_Y_PLAN_ACT_OBJ是要操作的表名,
SEQ_TBL_Y_PLAN_ACT_OBJ是创建的自增函数名;
9999999999 是根据字段的长度而定,本例字段长为10;
OBJ_ID是要表中需要自增的字段名称.