DBMS_RANDOM , 2 of 2

Summary of 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.

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

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.

Parameter	Description
seed	Seed number used to generate a random number.

This procedure resets the seed.

DBMS_RANDOM.SEED (
   seed  IN  BINARY_INTEGER);

Parameter	Description
`seed`	Seed number used to generate a random number.

This function gets the random number.

DBMS_RANDOM.RANDOM
   RETURN BINARY_INTEGER;

None.

my_random_number := Random;

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

DBMS_RANDOM.TERMINATE;

None.