Re: How to generate a random number

[Ray Ontko <rayo@ONTKO.COM>]

Alok,

This is a topic that comes up frequently.  For past conversations
and code samples, visit:

   http://www.sqrug.com/sqr-users/

and serach for "random".

Peter Burton wrote a particularly good one, as I reall.

Ray

> Hello everyone,
>
> I would like to generate a random number between 1 and
> 10. It needs to be a
> true random number. I searched SQR command reference
> and couldn't find a
> function to get a random number. I also checked Oracle
> documentation but no
> help.
>
> Any help will be well appreciated.
>
> Thanks!
>
> - Alok Kulshrestha
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Mail - Free email you can access from anywhere!
> http://mail.yahoo.com/
>

----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/