Oracle主键自增

1、创建table

CREATE TABLE demo6
(
    id INT NOT NULL,
    key1 VARCHAR2(40) NULL,
    key2 VARCHAR2(40) NULL
);

2、设置主键

alter table demo6 add constraint demo6_pk primary key (id);

3、新建序列

create sequence demo6_id
minvalue 1
nomaxvalue 
increment by 1 
start with 1
nocache;

4、新建触发器

create or replace trigger demo6_tg_insertId
before insert on demo6 for each row 
begin
  select demo6_id.Nextval into:new.id from dual;
end;

5、插入数据

insert into demo6 (key1, key2)
values ('key1', 'key2');
insert into demo6 (key1, key2)
values ('key11', 'key22');

6、查询table

select * from demo6;

 7、查询当前序列值

select demo6_id.currval from dual;

参考文章：http://www.cnblogs.com/dshore123/p/8267240.html

---