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
- 6364 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 to call shell script from pl sql procedure?
What will you get by the cursor attribute sql%found?
What is update query?
What is a common use of group by in sql?
What is trigger price?
what are the differences between char and nchar? : Sql dba
What are commit, rollback, and savepoint?
What is difference between inner join and self join?
How can we solve sql error: ora-00904: invalid identifier?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
What is difference between group by and partition by?
What is set serveroutput on?
what is the command line end user interface - mysql? : Sql dba
What is sql*loader and what is it used for? : aql loader
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
