Re: Random

From: FlameDance <FlameDance_at_gmx.de>
Date: Mon, 10 May 2004 14:36:55 +0200
Message-ID: <c7nt18$32r$06$1@news.t-online.com>

Sybrand Bakker wrote:

>>is there a function, in Oracle, to generate pseudo-random numbers (like RND
>>or RANDOM) ?
>>

> check out the dbms_random package in the Oracle supplied packages
> manual.
>

Note that this package is not compiled into the database by default during installation. If it doesn't work, you may have to run a few scripts as user sys first (this is for 9.0.2 under Windows, if you have another version it may vary):

%ORA_HOME%\rdbms\admin\dbmsoctk.sql
%ORA_HOME%\rdbms\admin\prvtoctk.plb
%ORA_HOME%\rdbms\admin\dbmsrand.sql

Stephan Received on Mon May 10 2004 - 07:36:55 CDT