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.

Examples

1
2
3
4
5

-- Generate a random number between 0 and 1:
SELECT DBMS_RANDOM.VALUE(0,1);

-- Add 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:
SELECT TRUNC(DBMS_RANDOM.VALUE(0,100));