how can stop the sequence with mention the max value and
with out mention the max value
- 1 Answers
- 5885 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
How is data stored on a disk?
Is it possible to sort a column using a column alias?
what are properties of a transaction? : Sql dba
what is sp_pkeys? : Transact sql
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
Does pl/sql support create command?
What is update query?
What is bulk collect in pl sql?
Can unique keys be null?
Why query optimization is needed?
What does truncate mean in sql?
how to create a test table in your mysql server? : Sql dba
What are data types in pl sql?
What is sqlservr exe?
How many types of keys are there in sql?
