Oracle表 设置自增

创建序列
create sequence ACCOUNT_SEQUENCE 
minvalue 1       
maxvalue 9999     
start with 1      
increment by 1   
nocache;  

创建触发器

create or replace
trigger Account_trigger
  before insert on "oracle_input"  
  for each row
declare
  nextid number;
begin
  IF :new."id" IS NULL or :new."id"=0 THEN  
    select ACCOUNT_SEQUENCE.nextval
    into nextid
    from sys.dual;
    :new."id":=nextid;   
  end if;
end Account_trigger; -