Re: Sequence numbers

[mvh_at_westmalle (Marcel van der Holst)]
|
| Hi all,
|
| I'm using an oracle sequence to generate unique numbers:
|
| sequence.nextval gives me the next unique number.
|
| The sequence caches 250 numbers and the increment is 1.
|
| The question is whether it is possible to ask to oracle for the next 100
| unique numbers in a single SQL call.

how about doing it in an anonymous PL/SQL block?

-Bjørn

-- 
 Bjørn Borud <borud_at_guardian.no>       | "The Net interprets censorship 
 <URL:http://www.pvv.unit.no/~borud/>  | as damage and routes around it."
 UNIX person, one of "them"            |         - John Gilmore