Oracle主键自增长

1.创建表
create table CUS_USER
(
ID NUMBER(10) not null primary key,
NAME VARCHAR2(20),
PASSWORD VARCHAR2(100)
);

2.创建序列
create sequence CUS_USER_ID
start with 1
increment by 1
nomaxvalue;

3.创建触发器
create or replace trigger user_trigger
before insert on cus_user
for each row
begin
select cus_user_id.nextval into :new.id from dual;
end;

4.测试
insert into cus_user(name,password)values(‘test’,’123456’);