sequences [message #371411] |
Sun, 15 October 2000 14:47 |
Chris
Messages: 128 Registered: November 1998
|
Senior Member |
|
|
Anybody know how to answer this question?
Write a script to display the following information about sequences;sequence name,maximum value,increment size,and last number
|
|
|
Re: sequences [message #371414 is a reply to message #371411] |
Mon, 16 October 2000 02:02 |
Sandeep Deshmukh
Messages: 13 Registered: October 2000
|
Junior Member |
|
|
Chris,
You can give a query on all_sequences or user_sequences to get the information.The structure is like this.
all_sequences
=============
SEQUENCE_OWNER
SEQUENCE_NAME
MIN_VALUE
MAX_VALUE
INCREMENT_BY
CYCLE_FLAG
ORDER_FLAG
CACHE_SIZE
LAST_NUMBER
You can write a query or report to extract the required information.
select sequence_name,min_value,max_value,increment_by,last_number from all_sequences
where sequence_name like concat(upper('&sname'),'%')
You need to format the columns as per the look & feel required.
Regards,
Sandeep
|
|
|