oracle中实现id自增主键
摘要:
oracle中自增主键一、创建sequenceCREATE SEQUENCE "SCOTT"."USER_ID_SEQUENCE"MINVALUE 1 MAXVALUE 999999999999999999999999999INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE ;二、创建触发器--创建触发器create or replace trigger user_triggerbefore insert on t_userfor each rowbegin select USER_ID_SEQUENC 阅读全文
posted @ 2012-03-27 15:12 风为裳 阅读(185) 评论(0) 推荐(0) 编辑