Re: Sequences...

Not as much as dropping it whilst its in use ;)

How about changing it to have max value = current value and cycle it - the next select puts it back to base, then nocycle it. (I haven't thought it through, just a quick idea).

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Remco Blaakmeer wrote in message <874rhh$esm$5_at_rd1936.quicknet.nl>...


>In article <38948567.222570158_at_news.eagles.bbs.net.au>,

> steve.adams_at_ixora.com.au (Steve Adams) writes:

>>

>> Not so. You can alter the sequence to have a large negative (presumably)

>> increment, select from it, and then reset the increment.

>

>This may cause a lot of fun if you're not the only one fetching values

>from the sequence. :-)

>

>Remco

>--

>rd1936:  9:25pm  up 23 days,  2:05,  7 users,  load average: 2.46, 2.22,

2.03