Oracle 自增列

--创建自增方法

--DROP SEQUENCE EBSIG_LECAKE.A_REGION_ID_SEQ;

CREATE SEQUENCE EBSIG_LECAKE.A_REGION_ID_SEQ
  START WITH 21
  MAXVALUE 999999999999999999999999
  MINVALUE 1
  NOCYCLE
  CACHE 20
  NOORDER;

　　

--添加触发器
create or replace trigger WM_StorageType_trigger 
before insert on WM_StorageType
for each row 
begin 
select A_REGION_ID_SEQ.nextval into:new.specID from sys.dual ;  -- specID  列名

end;

　　

转载于:https://www.cnblogs.com/feilong123/p/3179521.html