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%'
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