Re: more than one number from sequence

"Alan Mills" <Alan.Mills_at_nospamservices.fujitsu.com> writes:

> Pick any large (enough) table you have in your schema and then
>
> SELECT MySequence.NextVal
> FROM MyLargeTable
> Where ROWNUM < TheNumberIWant;

Thank you Alan,
 I'll use the 'helper table' approach without PL/SQL.

Bye,

Volker

-- 
Volker Apelt