oracle 序列检查

 

--序列检查
select SEQUENCE_OWNER,
       sequence_name,
       min_value,
       TO_CHAR(MAX_VALUE) MAX_VALUE,
       INCREMENT_BY,
       CYCLE_FLAG,
       ORDER_FLAG,
       CACHE_SIZE,
       LAST_NUMBER
  from dba_sequences
 where sequence_owner in ('');