Re: DBMS_RANDOM

From: Van Messner <vmessner_at_bestweb.net>
Date: 2000/03/25
Message-ID: <tnUC4.2397$rN.144724@monger.newsread.com>#1/1

DBMS_Random returns 8 digit integers until version 8.1.5. I don't have my 8.1.6 disks yet but how huge are the numbers you're seeing? With 8 digit numbers you can truncate/mod/etc to map the 8 digits into some number between 0 and 365,

Van

Eugene Firyago <efiryago_at_bisys.com> wrote in message news:8bg5jt$a3c$1_at_bob.news.rcn.net...
> 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.
>
>
>
Received on Sat Mar 25 2000 - 00:00:00 CST