Tuesday, October 9, 2007

How to retrieve a Sequence Value?

What is the easiest way to set a sequence to a very high value.

E.g. currval = 100, set it to point to 1100.

Instead of dropping and recreating the sequence again, use the INCREMENT BY option to reset a sequence value. You can also decrement the sequence value by incrementing it with a negative number. Don't forget to reset the increment value to 1 or as the case.

Alter sequence x increment by 1000;select x.nextval from dual;Alter sequence x increment by 1; Tip taken from:http://www.amar-padhi.com/oradb_seq_reset.html

5 comments:

Xia Zhang said...

http://www.shopbestgoods.com/
http://www.bestcustomsonline.com/
http://www.nike-jordanshoes.com/
http://www.polo-tshirts.com/
http://www.burberry-factory.com/
http://www.kate-spades.com/
http://www.barbour-factory.com/
http://www.coachlosangeles.com/
http://www.official-coachoutlet.com/
http://www.louisvuittonas.com/
http://www.burberryoutlet2014.com/
http://www.official-mkoutlet.com/
http://www.official-pradaoutlet.com/
http://www.beatsbydreoutlet.net/
http://www.michaelkorsonlineusa.com/
http://www.northsclearance.com/
http://www.ralph-laurensale.com/
http://www.gucci-shoesuk2014.com/
http://www.michael-korsusa.com/
http://www.polo-outlets.com/
http://www.hermes-outletonline.com/
http://www.ralphslauren.co.uk/
http://www.marcjacobsonsale.com/
http://www.mcmworldwides.com/
http://www.warmbootssale.com/
http://www.salongchamppairs.com/
http://www.canada-gooser.com/
http://www.michaelkors.so/
http://www.oakley-sunglassoutlet.com/
http://www.north-faceoutlets.net/
http://www.moncler-clearance.com/
http://www.woolrich-clearance.com/
http://www.barbour-jacketsoutlet.com/
http://www.moncler-jacketsoutletonline.com/
http://www.monsterbeatsbydres.net/
http://www.lv-guccishoesfactory.com/
http://www.cheapdiscountoutlet.com/
http://www.coachsfactoryoutlet.com/
http://www.coach-blackfriday2014.com/
http://www.coach-storeoutletonline.com/
http://www.coach-factorysoutletonline.com/
http://www.coachccoachoutlet.com/
http://www.coach-factories.net/
http://www.coach-pursesoutletonline.com/
http://www.coach-outletsusa.com/
http://www.zxcoachoutlet.com/
http://www.mischristmas.com/
http://www.misblackfriday.com/
http://www.newoutletonlinemall.com/
http://www.ralphlaurenepolo.com/
http://michaelkorsoutlet.mischristmas.com/
http://mcmbackpack.mischristmas.com/
http://monsterbeats.mischristmas.com/
http://northfaceoutlet.mischristmas.com/
http://mk.misblackfriday.com/
http://coachoutlet.misblackfriday.com/
http://coachfactory.misblackfriday.com/
http://uggaustralia.misblackfriday.com/
http://coachpurses.misblackfriday.com/
http://coachusa.misblackfriday.com/
http://coach.misblackfriday.com/
http://michaelkorss.misblackfriday.com/
http://michaelkors.misblackfriday.com/
http://airmax.misblackfriday.com/
http://michael-kors.misblackfriday.com/
https://twitter.com/CoachOutlet2014
https://www.facebook.com/coachoutletstoreonline
https://www.facebook.com/ralphlaurenoutletonline

dong dong23 said...

coach outlet
ray ban
coach outlet
lebron james shoes 2015
michael kors outlet
lebron james shoes 12
nike uk
louis vuitton
louis vuitton
nike running shoes
jordan 3 infrared
coach outlet
michael kors
louis vuitton outlet
polo ralph lauren
fitflops
burberry outlet
burberry outlet
michael kors outlet
michael kors outlet clearance
cartier watches
north face outlet
ralph lauren polo outlet
nfl jerseys wholesale
michael kors outlet
jordan 6
toms outlet
longchamp handbags
adidas trainers
nike trainers
polo ralph lauren outlet
michael kors outlet
michael kors outlet clearance
coach canada
christian louboutin sale
louis vuitton outlet stores
michael kors outlet
replica watches
coach factory outlet
kobe 11
20166.4wengdongdong

annamagile said...

The AP reported that Manziel's lawyer Bob Hinton mistakenly sent the AP a long text message, which he said later was meant for another attorney,wholesale Indiana Colts flags,
cheap Indianapolis Colts flags,nfl sports flags

annamagile said...

Da allora a oggi le squadre sono cambiate ma nemmeno troppo. Camisetas de futbol baratas,camisetas AC Milan,
camisetas As Roma baratas

annamagile said...

Ben 19 infatti i giocatori, più Del Bosque, presenti allora come oggi: chi con le stesse responsabilità,
http://segoviaformacion.com/maglie.asp?calcio=index
http://viveroshontoria.com/maglie.asp?calcio=index
http://www.smiolesa.com/maglie.asp?prezzo=index
http://silicesgomezvallejo.com/maglie.asp?prezzo=index
www.globales.es/maglie.asp?magliette=index
maglie calcio,maglia serie a italia,maglia AC milan 2017