Thursday 20 September 2012

How to get list of sequences in oracle?

Query is : 

SELECT * from user_sequences 
     

Describe user_sequences

SEQUENCE_NAME    VARCHAR2(30)
MIN_VALUE                NUMBER      
MAX_VALUE              NUMBER      
INCREMENT_BY        NUMBER      
CYCLE_FLAG             VARCHAR2(1)
ORDER_FLAG            VARCHAR2(1)
CACHE_SIZE              NUMBER      
LAST_NUMBER         NUMBER       


we can search in between also :

SELECT * from user_sequences where sequence_name like '%Doctor%'

No comments:

Post a Comment