oracle创建自增序列

//先创建序列
create sequence CLGL_DEPTADJUST_ONLYID_SEQ
minvalue 1
maxvalue 99999999
start with 1
increment by 1
nocache;

 

 

//再创建自增字段的触发器
CREATE OR REPLACE TRIGGER CLGL_DEPTADJUST_ONLYID_TRG BEFORE INSERT OR UPDATE ON CLGL_DEPTADJUST 
  FOR EACH ROW 

 

DECLARE 
  v_newVal NUMBER(12) := 0; 
BEGIN 
    IF INSERTING THEN 
      SELECT CLGL_DEPTADJUST_ONLYID_SEQ.NEXTVAL INTO v_newVal FROM DUAL; 
     sqlserver_utilities.identity := v_newVal; 
     :new.ONLYID := v_newVal; 
    END IF; 
END;