Home » SQL & PL/SQL » SQL & PL/SQL » sequence Number (Oracle 9.2.0.6)
sequence Number [message #314075] Tue, 15 April 2008 14:49 Go to next message
Lucky A
Messages: 65
Registered: October 2007
Member
Hi,

Currently, I have a sequence number that is too low compare to the MAXVALUE. How can I reset the sequence number of the current value or Next_value that is (45000) to a value of 1001456?

Lucky
Re: sequence Number [message #314079 is a reply to message #314075] Tue, 15 April 2008 15:09 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, set the increment to the difference get the next value and reset back the increment to the previous value.

Regards
Michel
Re: sequence Number [message #314090 is a reply to message #314075] Tue, 15 April 2008 15:21 Go to previous message
Lucky A
Messages: 65
Registered: October 2007
Member
Thanks Michel. It worked beautifully.

Lucky.
Previous Topic: Error in PL/SQL Language Reference .... could be that possible ?
Next Topic: Trying to sort within a multiple UNION sql
Goto Forum:
  


Current Time: Sat Dec 10 08:43:29 CST 2016

Total time taken to generate the page: 0.24428 seconds