oracle自增长

1.主键

alter table T_RG_ADMINISTRATION add constraint id primary key(id)

 2.创建序列
create sequence seq_administration minvalue 1 nomaxvalue start with 1 increment by 1 nocycle cache 20

3.创建触发器，注意带‘；’，封号必须带
create or replace trigger tr_administration before insert on  T_RG_ADMINISTRATION for each row when (new.id is null)
 begin
    select  seq_administration.nextval into:new.id from sys.dual;
 end;

 

测试insert into  T_RG_ADMINISTRATION(AREA_NAME,AREA_code,IS_LOW_TERRAIN,IS_FLOOD_THREAT)values('雨花社区','320114001001',0,0)