The basic function gets a random number, greater than or equal to 0 and less than 1, with 38 digits to the right of the decimal (38-digit precision).
Alternatively, you can get a random Oracle number x, where x is greater than or equal to low and less than high.
SELECT DBMS_RANDOM.VALUE,DBMS_RANDOM.VALUE(1,100) FROM DUAL;
Alternatively, you can get a random Oracle number x, where x is greater than or equal to low and less than high.
SELECT DBMS_RANDOM.VALUE,DBMS_RANDOM.VALUE(1,100) FROM DUAL;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/638844/viewspace-1062170/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
