[置顶] 个人笔记-oracle

序列

select * from user_sequences 
select last_number from user_sequences where sequence_name="T_JGXX_POLY_SEQ";
alter sequence T_JGXX_POLY_SEQ increment by 1;
SELECT T_JGXX_POLY_SEQ.NEXTVAL FROM DUAL;select * from user_sequences 
select last_num