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
- 6498 Views
- Zensar, I also Faced
- E-Mail Answers
Answer / 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 |
What is left join example?
I have a CURSOR then why we need BULK COLLECT again?
What is the use of function "module procedure" in pl/sql?
Is not null in sql?
What are the dml statements?
What is sql and its types?
With out using count() function. How to the find total number of rows in a table?
What is sql lookup?
how to increment dates by 1 in mysql? : Sql dba
Does sql backup shrink transaction log?
how many columns can be used for creating index? : Sql dba
How to access the current value and next value from a sequence?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
