Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

How does a self join work?

0 Answers  

How to display the current date in sql?

0 Answers  

what is meant by nl2br()? : Sql dba

0 Answers  

how to retrive only second row from table?

31 Answers   IBM,

What is foreign key sql?

0 Answers  

Which is better varchar or nvarchar?

0 Answers  

What are sql built in functions?

0 Answers  

What are the two characteristics of a primary key?

0 Answers  

Is pl sql better than sql?

0 Answers  

what is global table

7 Answers   iFlex,

What is audit logout in sql profiler?

0 Answers  

Can a key be both primary and foreign?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories