DBMS_RANDOM

Related Interfaces

Table 1 provides all interfaces supported by the DBMS_RANDOM package.

• DBMS_RANDOM.SEED

  The stored procedure SEED is used to set a seed for a random number. The DBMS_RANDOM.SEED function prototype is:

  1	DBMS_RANDOM.SEED (seed IN INTEGER);

  Table 2 DBMS_RANDOM.SEED interface parameters

  Parameter	Description
  seed	Generates a seed for a random number.

• DBMS_RANDOM.VALUE

  The stored procedure VALUE generates a random number between a specified low and a specified high. The DBMS_RANDOM.VALUE function prototype is:

  1 2 3 4

  DBMS_RANDOM.VALUE( low IN NUMBER, high IN NUMBER) RETURN NUMBER;

  Table 3 DBMS_RANDOM.VALUE interface parameters

  Parameter	Description
  low	Sets the low bound for a random number. The generated random number is greater than or equal to the low.
  high	Sets the high bound for a random number. The generated random number is less than the high.

The only requirement is that the parameter type is NUMERIC regardless of the right and left bound values.

Example

Generate a random number between 0 and 1.

1

SELECT DBMS_RANDOM.VALUE(0,1);

Specify the low and high parameters to an integer within the specified range and intercept smaller values from the result. (The maximum value cannot be a possible value.) Therefore, use the following code for an integer between 0 and 99:

1

SELECT TRUNC(DBMS_RANDOM.VALUE(0,100));