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

What is a 'instead of trigger'?

3 Answers   Eenadu, TCS,

How does postgresql compare to "nosql"?

0 Answers  

how to use regular expression in pattern match conditions? : Sql dba

0 Answers  

What is the life of an sql statement?

0 Answers  

there are .......different types of serializability

1 Answers   Wipro,

What is the difference between anonymous block and named blocks?

3 Answers  

I want to display the employees who have joined in last two months. (It should be executed randomly means If I execute the query in March it should display Jan and Feb joined employees. Same query if i execute in Feb, 2007 it should display dec, 2006 and jan 2007 joined employees.

15 Answers   Wipro,

What are the various levels of constraints?

0 Answers  

How do I save a sql query?

0 Answers  

How can you create Cursor with parametres ?

3 Answers  

What are types of exception?

0 Answers  

can i give user defined exception in a package

2 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories