Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Random
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
![]() |
![]() |