Monday, January 26, 2015

Displays List of Sequence in Oracle Database

select  substr(sequence_owner,1,10)             "OWNER",
        substr(sequence_name,1,25)              "SEQ NAME",
        substr(to_char(min_value),1,3)          "MIN",
 max_value    "MAX",
 increment_by    "INC",
      cache_size    "CACHE",
 last_number    "LAST NUM"
from  all_sequences
order by 1 asc, 2 asc;

No comments:

Post a Comment