Re: Random

From: FlameDance <FlameDance_at_gmx.de>
Date: Mon, 10 May 2004 14:36:55 +0200
Message-ID: <c7nt18$32r$06$1_at_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 - 14:36:55 CEST

This message: [ Message body ]
Next message: Daniel Morgan: "Re: Displaying only 1 of 2 detail blocks depending on value of attribute in master block"
Previous message: lavenderNY: "looking for Oracle DBA study companion"
In reply to: Sybrand Bakker: "Re: Random"
Next in thread: Daniel Morgan: "Re: Displaying only 1 of 2 detail blocks depending on value of attribute in master block"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message