oracle 自增列设立

create sequence sq_1minvalue 1maxvalue 9999999999999999999999999999start with 1increment by 1cache 2000;

create or replace trigger 触发器名字  before insert on 表名    for each rowdeclare  -- local variables herebegin   SELECT sq_1.nextval  INTO :NEW.列名  FROM DUAL;end 触发器名字;

insert into gd(id) values(sq_1.nextval);