oracle 11g实现主键自增

创建序列

create sequence nt_bas_dw_dwid_seq
minvalue 0
nomaxvalue
start with 0
increment by 1
nocache;

删除序列

DROP sequence nt_bas_dw_dwid_seq;

参数说明：

查询序列

select nt_bas_dw_dwid_seq.nextval from dual;

创建触发器

create or replace trigger NT_BAS_DW_insertId
before insert on DZJKS.NT_BAS_DW
for each row 
begin
select nt_bas_dw_dwid_seq.nextval into:new.DW_ID from dual;
end;

参数说明：

删除触发器

drop trigger NT_BAS_DW_insertId