On this page

DBMS_RANDOM

Updated on 2024-12-19 GMT+08:00

Related Interfaces

Table 1 provides all interfaces supported by the DBMS_RANDOM package.

Table 1 DBMS_RANDOM interface parameters

Interface

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:

    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.

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.

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));
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback