oracle中实现id自增主键
oracle中自增主键
一、创建sequence
CREATE SEQUENCE "SCOTT"."USER_ID_SEQUENCE"
MINVALUE 1 MAXVALUE 999999999999999999999999999
INCREMENT BY 1 START WITH 1 NOCACHE NOORDER NOCYCLE ;
二、创建触发器
--创建触发器
create or replace trigger user_trigger
before insert on t_user
for each row
begin select USER_ID_SEQUENCE.nextval into :new.id from dual;
end;