Oracle数据库 设置主键自增

``create sequence consul_id_sequence
increment by 1
start with 1
nomaxvalue
nocache;

create trigger consul_id_autoincrement before
insert on empcare_consult for each row
when (new.id is null)
begin
select consul_id_sequence.nextval into:new.id from dual;
end;