Home » SQL & PL/SQL » Client Tools » some useful tip about sequences
some useful tip about sequences [message #246896] Fri, 22 June 2007 07:01 Go to next message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Hi,

Does anybody know some useful tool with option to set (increase/decrease) sequencer to user value?

Thanks!
Re: some useful tip about sequences [message #246897 is a reply to message #246896] Fri, 22 June 2007 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Can you precise your question?

Regards
Michel
Re: some useful tip about sequences [message #246940 is a reply to message #246896] Fri, 22 June 2007 10:02 Go to previous message
majstoru
Messages: 68
Registered: October 2006
Location: Serbia
Member
Here is few samples:

1. At the end of year DB is empty some tables and to set their qequences to 0.
2. When I bring new records of table reports to setup max(id) as next sequence value.
3. When import data from previous system where id (which is generated by sequencers) is fix and I input that filed too, to set up max(id)+1 as next value.
...

Thanks Michael!
Previous Topic: spool without user respons
Next Topic: Error while starting SQLPLUS!!!!!!
Goto Forum:
  


Current Time: Thu Dec 08 08:28:04 CST 2016

Total time taken to generate the page: 0.10493 seconds