Help Center > > Developer Guide> Stored Procedures> Advanced Packages> DBMS_RANDOM

DBMS_RANDOM

Updated at: Jul 15, 2020 GMT+08:00

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:

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel