oracle 主键ID自动增长的解决！

1.首先创建表 着先不用说了！

2.创建 序列 ！

DROP SEQUENCE SCOTT.SEQUENCE_NAME;

CREATE SEQUENCE SCOTT.SEQUENCE_NAME

  START WITH 1
  MAXVALUE 999999999999999999999999999
  MINVALUE 0
  NOCYCLE
  CACHE 20
  NOORDER;

3.创建 触发器 TRIGGER

DROP TRIGGER SCOTT.TIGER_NAME;

CREATE OR REPLACE TRIGGER SCOTT.TIGER_NAME
BEFORE INSERT
ON SCOTT.LEIBIE   //数据库中的表名
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
declare next_id number;
BEGIN
   select
        SCOTT.SEQUENCE_NAME.nextval into next_id from  dual;
         :new.id   :=   next_id;  

  

TIGER_NAME;