Oracle通过触发器设置表主键递增

• T_IDS_GPS_CASHCAR_SEQ:自定义唯一标识序列名，一般为T _ 表名 _ SQE
• IDS_GPS_CASHCAR:表名
• trigger_ids_gps_cashcar:触发器名
• id:设置递增的表栏位名称

create sequence T_IDS_GPS_CASHCAR_SEQ   ---序列名
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1;

create or replace trigger trigger_ids_gps_cashcar  ---触发器名
before insert on IDS_GPS_CASHCAR  ---表名
for each row
begin
select T_IDS_GPS_CASHCAR_SEQ.nextval into :new.id from dual;   ---id 为表IDS_GPS_CASHCAR设置递增的栏位
end trigger_ids_gps_cashcar;