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.
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.
我要的是一组随机数啊回:jlandzpa(欧高黎嘉陈)
ORACLE 9I的光盘我有的,就是用的有问题才发贴还是感谢两位
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
------------------------
80.687389至于返回一组随机数,dbms_random好像没有这个function吧。做个循环每次返回一个不就是一组了吗^_^
----------
330真是想偷懒都不行?
而且这组数中不允许有重复的值!!!