Oracle笔记----oracle数字类型number自增
创建序列 create sequence seq_student start with 6 increment by 1 maxvalue 500 nominvalue nocycle nocache; 创建触发器 create or replace trigger trigger_student before insert on student for each row declare BEGIN select seq_student.nextval into :new.id from dual; END;
--------------------------------------------------------------------------------------------------------------------------------------------
作者:Honey_Badger —— 觉得这文章好,点一下左下角
出处:http://tk55.cnblogs.com/
posted on 2017-08-24 09:16 Honey_Badger 阅读(876) 评论(0) 编辑 收藏 举报