oracle设置自增ID

CREATE SEQUENCE 序列名
START WITH 1
INCREMENT BY 1
MINVALUE 1
ORDER
NOCYCLE;

//CREATE SEQUENCE “QMS”.“Untitled” MINVALUE 1 INCREMENT BY 1 START WITH 1 ORDER NOCACHE
创建触发器：
create or replace trigger 触发器名
before insert on “表名” for each row
begin
select 序列表名.nextval into :new.“自增的字段” from dual;
end;