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
- 6394 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 are the key differences between SQL and PL SQL?
What are the types of subqueries?
What are the two types of exceptions in pl/sql?
What is scalar function in sql?
Can you do multiple joins in sql?
What is the difference between a primary key and a unique key?
Explian rowid, rownum? What are the psoducolumns we have?
What is difference between hql and sql?
What is count * in sql?
What are the features of pl sql?
Why function is used in sql?
What is right join sql?
What is the difference between cluster and non-cluster index?
How do I count rows in sql?
What are all different types of collation sensitivity?
