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;