Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Random numbers in Oracle
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