http://www.cnblogs.com/yomho/p/3714574.html
//创建序列
SQL>create sequence log_seq
increment by 1
start with 1
nomaxvalue
order
nocycle
cache 10;
//创建触发器
SQL>create or replace trigger log_seq_trig
before insert on OPERATELOG
for each row
begin
select log_seq.nextval into :new.log_id from dual;
end log_seq_trig;
/
//查看当前用户的所有序列
select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner='用户名';
//查询序列的下一个值(查询一次就增长一次)
select LOG_SEQ.NEXTVAL FROM DUAL;
//不删除序列的情况下重置序列数
select JBR_REPORT_SEQ.nextval from dual;
alter sequence JBR_REPORT_SEQ increment by -8;
select JBR_REPORT_SEQ.nextval from dual;
alter sequence JBR_REPORT_SEQ increment by 1;
//查询某个表所拥有的触发器
select trigger_name from all_triggers where table_name='XXX';
//查询某个触发器的详细信息
select text from all_source where type='TRIGGER' AND name='TR_XXX';