Re: How to generate random number (up to 7 digits) in Oracle?

From: ritchie turner <rmturner_at_utouch.com>
Date: Fri, 06 Aug 1999 11:04:31 -0400
Message-ID: <37AAF97F.D3B9DC00@utouch.com>

I don't know if this link os of any help I found it yesterday in a thread in this group, I believe it's an implementation of an RNG.

http://www.deja.com/[ST_rn=ps]/getdoc.xp?AN=490388693&fmt=text

Leon LI wrote:

> Hi,
>
> Could you give me a hint on how to generate random
> numbers (up to 7 or 8 digits) in Oracle. The idea is
> to randomly select 100 account for creating
> a snapshot. The account number is up to 7 or 8 digits.
>
> Any help is highly appreciated.
>
> Regards,
>
> Leon,
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!
Received on Fri Aug 06 1999 - 10:04:31 CDT