序列
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 触发器名字;
SQL语句
insert into gd(id) values(sq_1.nextval);
原标题:oracle 自增列设置
关键词:oracle