Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Random numbers in Oracle

Re: Random numbers in Oracle

From: Michael A. Rife <MRife_at_admin.usf.edu>
Date: 1997/05/30
Message-ID: <5mnb2f$j3s$1@news.usf.edu>#1/1

Where is the BITAND function? I did not know that Oracle's PL/SQL had the BITAND function.

In article <01bc6b1c$e08992e0$8c9dcdcd_at_default>, cecil_at_total.net says...
>FUNCTION Rand RETURN NUMBER IS
>BEGIN
> v_Seed := MOD(v_Multiplier * v_Seed + v_Increment, (2 ** 32));
> RETURN BITAND(v_Seed/(2 ** 16), 32767);
>END Rand;
Received on Fri May 30 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US