--创建自增方法
--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;