1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

how can stop the sequence with mention the max value and
with out mention the max value

Question Posted / suresh


how can stop the sequence with mention the max value and with out mention the max value..

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

Post New Answer

More SQL PLSQL Interview Questions

What is indexing in sql and its types?

0 Answers  

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

how can we replace the particular column value of a resulted set of executed query? I mean write down a sql query to chane the particular column's value of a resulted set of executed query

3 Answers  

What are sql functions? Describe in brief different types of sql functions?

0 Answers  

describe transaction-safe table types in mysql : sql dba

0 Answers  




Is sql procedural language?

0 Answers  

What is sql and explain its components?

0 Answers  

using subquery how can i calculate working days in a month?

3 Answers   Spice Telecom,

Delete the emps whose salaries are lowest sals of their own dept.

5 Answers  

What is sql*loader?

0 Answers  

Explain what is a database?

0 Answers  

Which one is faster ienumerable or iqueryable?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories