oracle自增id触发器编写

--查看当前用户的序列

select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner='GGZYZTB' and SEQUENCE_NAME='ZTB_RESULT_NOTICE_SEQ' ;


 
--删除序列

DROP SEQUENCE ZTB_RESULT_NOTICE_SEQ
 
 
--创建自增序列 
create sequence GGZYZTB.ZTB_RESULT_NOTICE_SEQ
minvalue 1
maxvalue 999999
start with 203999
increment by 1
nocache;


 --查看序列下一个值
SELECT ZTB_RESULT_NOTICE_SEQ.NEXTVAL  FROM dual;
 
 --创建触发器
create or replace trigger GGZYZTB.ZTB_RESULT_NOTICE_Trigger
before insert on GGZYZTB.ZTB_RESULT_NOTICE for each row
begin
select GGZYZTB.ZTB_RESULT_NOTICE_SEQ.nextval into :new.IID  from dual;
end;


--查看触发器状态
sELECT * FROM DBA_OBJECTS WHERE OBJECT_TYPE='TRIGGER'and OBJECT_NAME = 'ZTBTRIGGER';