On 25-03-2011 12:02 PM, Thomas Steinmaurer wrote:

>>> A throw-away SEQUENCE would also do the trick, I think:
>>>
>>> sql> create sequence AdHoc;
>>> sql> select next value for AdHoc as SrNo, d.* FROM (...) d;
>>>
>>> -Mike
>>>
>>>
>> This is exactly what I want.
> Needless to say, if the generator/sequence is used by multiple users,
> then this isn't safe.
>
>

And also, it will exhaust after 32000 queries am i right (if a new
sequence is used every time)?

Thanks,

Jaison.