DBMS_RANDOM

Related Interfaces

Table 1 provides all interfaces supported by the DBMS_RANDOM package.

Table 1 DBMS_RANDOM interface parameters

API	Description
DBMS_RANDOM.SEED	Sets a seed for a random number.
DBMS_RANDOM.VALUE	Generates a random number between a specified low and a specified high.

• DBMS_RANDOM.SEED

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

  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:

  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.

Note

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:

SELECT DBMS_RANDOM.VALUE(0,1);

Generate a random integer ranging from 0 to 100. The random integer is greater than or equal to the specified value of low and less than the specified value of high.

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

last updated: 2025-09-11 15:37 UTC - commit: 0936b7736854a5d1860e596c7749139402140c8a