//设置自增索引名
create sequence GJGX_seq
increment by 1
start with 1
maxvalue 999999999 ;
//关联到表
create trigger GJGX_tri before
insert on
GJGX_QUERYLOG(表名) for each row
when (new.id is null)
begin
select (自增索引名)GJGX_seq.nextval into:new.id from dual;
end;