如何使用dbms_random，如何返回一组随机数？

suntsang 2002-09-27 05:37:16

其他函数也可:)

...全文

270 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

suntsang 2002-09-28

打赏
举报

SQL> select ceil(dbms_random.value(1,(select count(*) from cat)))"RandomNum" from dual;

RandomNum
----------
330

真是想偷懒都不行?
而且这组数中不允许有重复的值!!!

zhaoyongzhu 2002-09-28

打赏
举报

SQL> select dbms_random.value(1,100) from dual;

DBMS_RANDOM.VALUE(1,100)
------------------------
80.687389

至于返回一组随机数，dbms_random好像没有这个function吧。做个循环每次返回一个不就是一组了吗^_^

suntsang 2002-09-28

打赏
举报

up
对了应该是一定范围内的一组随机数,譬如1-100

suntsang 2002-09-28

打赏
举报

up
没人可以解决？？？

suntsang 2002-09-27

打赏
举报

就是一次返回多个随机数啊:)

jlandzpa 2002-09-27

打赏
举报

什么问题呀？
17:44:03 jlanzpa817>select dbms_random.random from dual;

1328509000

已用时间: 00: 00: 04.46
17:48:57 jlanzpa817>select dbms_random.random from dual;

-979702366

已用时间: 00: 00: 06.20
18:15:00 jlanzpa817>/

-247042050

已用时间: 00: 00: 05.38

suntsang 2002-09-27

打赏
举报

回:zhaoyongzhu(zhaoyongzhu)
我要的是一组随机数啊

回:jlandzpa(欧高黎嘉陈)
ORACLE 9I的光盘我有的,就是用的有问题才发贴

还是感谢两位

jlandzpa 2002-09-27

打赏
举报

DBMS_RANDOM
The DBMS_RANDOM package provides a built-in random number generator. It is faster than generators written in PL/SQL because it calls Oracle's internal random number generator.

Requirements
DBMS_RANDOM must be initialized prior to calling the random number generator. The generator produces 8 digit integers. If the initialization subprogram is not called, then the package raises an exception.

Summary of Subprograms
Table 30-1 DBMS_RANDOM Package Subprograms
Subprogram Description
INITIALIZE procedure

Initializes the package with a seed value.

SEED procedure

Resets the seed.

RANDOM function

Gets the random number.

TERMINATE procedure

Closes the package.

INITIALIZE procedure
To use the package, first call the initialize subprogram with the seed to use.

Syntax
DBMS_RANDOM.INITIALIZE (
seed IN BINARY_INTEGER);

--------------------------------------------------------------------------------
Note:
Use a seed that is sufficiently large, more than 5 digits. A single digit might not return sufficiently random numbers.

--------------------------------------------------------------------------------

Parameters
Table 30-2 INITIALIZE Procedure Parameters
Parameter Description
seed

Seed number used to generate a random number.

SEED procedure
This procedure resets the seed.

Syntax
DBMS_RANDOM.SEED (
seed IN BINARY_INTEGER);

Parameters
Table 30-3 INITIALIZE Procedure Parameters
Parameter Description
seed
Seed number used to generate a random number.

RANDOM function
This function gets the random number.

Syntax
DBMS_RANDOM.RANDOM
RETURN BINARY_INTEGER;

Parameters
None.

Example
my_random_number := Random;

TERMINATE procedure
When you are finished with the package, call the TERMINATE procedure.

Syntax
DBMS_RANDOM.TERMINATE;

Parameters
None.

zhaoyongzhu 2002-09-27