Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
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.
This chapter discusses the following topics:
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.
Subprogram | Description |
---|---|
Initializes the package with a seed value. |
|
Resets the seed. |
|
Gets the random number. |
|
Closes the package. |
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|