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
- 6415 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 |
how to insert the records in particular position
how to convert numeric values to character strings? : Sql dba
How to move files from one directory to another in pl sql?
what is single byte over head in oracle..?
Which are the different case manipulation functions in sql?
What is procedure and function?
When do we use triggers?
How can I tell if sql is running?
What is INSTEAD OF trigger ?
how to drop an existing table in mysql? : Sql dba
Which are the most commonly used sql joins?
What is union and union all keyword in sql and what are their differences?
-
Oracle (3259) - 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)
