oracle表设置主键自增长

create or replace table TBL_SYS_USER
(
  user_id             NUMBER(19) not null,
  user_name           VARCHAR2(60 CHAR),
  user_pwd            VARCHAR2(60 CHAR)
)

alter table TBL_SYS_USER
  add primary key (ID)
  using index
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );

--创建主键sequence:TBL_USER_SEQUENCE

create sequence TBL_SYS_USER_SEQUENCE
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;

--(TBL_SYS_USER)用户表主键自动添加触发器

CREATE OR REPLACE TRIGGER TBL_SYS_USER_TG
  BEFORE INSERT ON TBL_SYS_USER
  FOR EACH ROW
  WHEN (new.user_id is null)
begin
  select TBL_SYS_USER_SEQUENCE.nextval into :new.user_id from dual;
end;

--测试 可以看到添加TBL_SYS_USER记录时，主键user_id自动增加
insert into  TBL_SYS_USER(user_name,user_pwd )values('admin','admin');

转载于:https://www.cnblogs.com/liuruitao/p/4994555.html