how can stop the sequence with mention the max value and
with out mention the max value
- 1 Answers
- 5724 Views
- Zensar, I also Faced
- E-Mail Answers
Answer Posted / lipika
To create a sequence that stops at a predefined limit, for
an ascending sequence, specify a value for the MAXVALUE
parameter.
For a descending sequence, specify a value for the MINVALUE
parameter. Also specify NOCYCLE. Any attempt to generate a
sequence number once the sequence has reached its limit
results in an error.
NOTE:-Interval between the sequence value must be less than
the difference of MAXVALUE and MINVALUE. If this value is
negative, then the sequence descends. If the value is
positive, then the sequence ascends. If you omit this
clause, then the interval defaults to 1.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is update query?
What is the need of merge statement?
How does cross join work?
Why we use join in sql?
Explain what is an index?
What port does sql server use?
Which is better join or inner query?
Can sql function call stored procedure?
What is a memo field?
What is the execution plan in sql?
What is the difference between the sql*loader and import utilities? : aql loader
Does sql view stored data?
What is using in sql?
What is the location of pre_defined_functions.
What is the difference between explicit and implicit cursors in oracle?
