Re: DBMS_RANDOM

In article <8bg5jt$a3c$1_at_bob.news.rcn.net>, "Eugene Firyago" <efiryago_at_bisys.com> wrote:
> Does anybody use DBMS_RANDOM?
>
> My task is to have numbers randomly generated between 0 and 365 in
 PL/SQL. I
> tried to use DBMS_RANDOM (8.1.6) but I couldn't understand how does
 it work.
> The +/- numbers it generates are so huge and have no clear dependency
 on
> SEED parameter that's only one available to adjust generating.
>
> Any idea?
>
> Thanks,
> Eugene.
>

Eugene, It was a very long time ago but in college I learned the way to produce return values within a range using a random number generator is to take the result of the generator and divide it by the size of the range and take the remainder, i.e., use the mod function on the result of the call.

What do you mean by 'have no clear dependency on SEED parameter'?

--
Mark D. Powell -- The only advice that counts is the advice that
you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.