Interested to Buy Any Domain ? << Click Here >> for more details...
how can stop the sequence with mention the max value and
with out mention the max value
- 1 Answers
- 6274 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
Sql technical questions
what is a field in a database ? : Sql dba
does sql support programming? : Sql dba
How do you optimize a query?
Is a foreign key always unique?
How do you optimize a stored procedure query?
What are the types of variable use in pl sql?
Explain lock escalation? : Transact sql
What are the events on which a database trigger can be based?
what is a table in a database ? : Sql dba
Which is better varchar or nvarchar?
What is the difference between between and in condition operators?
How to pipe multiline string to isql?
What is recursive join in sql?
What is the difference between left outer join and left join?
