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 many tables will create when we create table, what are they? : Sql dba

0 Answers  

Is truncate ddl or dml?

0 Answers  

What is pl/sql table? Why is it used?

0 Answers  

Does pl/sql support create command?

0 Answers  

What does bitemporal mean?

0 Answers  

How to generate a salary slip like jan 1000 1000 feb 1000 2000 ... dec 1000 12000

0 Answers   BT,

What is difference between table and view?

0 Answers  

Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  

How did you export data from database to excel file.

1 Answers   TCS,

how to create a primary key with out creating an index?

9 Answers   TCS,

what is organisational index?

1 Answers  

What types of commands can be executed in sql*plus?

0 Answers  

For more SQL PLSQL Interview Questions Click Here
Categories