VALUE functions
Translation reference for DBMS_RANDOM.VALUE.
Description
The basic function gets a random number, greater than or equal to 0 and less than 1. Alternatively, you can get a random Oracle number
X
, whereX
is greater than or equal tolow
and less thanhigh
. (Oracle PL/SQL DBMS_RANDOM.VALUE)
This UDF is implemented using the Math.random function of Javascript to replicate the functionality of Oracle DBMS_RANDOM.VALUE function.
Syntax
Custom UDF overloads
Setup data
The DBMS_RANDOM
schema must be created.
DBMS_RANDOM.VALUE()
Parameters
No parameters.
Usage example
Oracle
Snowflake
DBMS_RANDOM.VALUE(NUMBER, NUMBER)
Parameters
low: The lowest
NUMBER
from which a random number is generated. The number generated is greater than or equal tolow
.high: The highest
NUMBER
used as a limit when generating a random number. The number generated will be less thanhigh
.
Usage example
Oracle
Snowflake
Known Issues
No issues were found.
Related EWIs
SSC-FDM-OR0033: DBMS_RANDOM.VALUE Built-In Package precision is lower in Snowflake.
Related EWIs
SSC-EWI-OR0112: DBMS_RANDOM.VALUE digits of presicion is lower in Snowflake.
Last updated