Oracle取随机数函数

最新推荐文章于 2024-01-18 11:26:32 发布

原创最新推荐文章于 2024-01-18 11:26:32 发布 · 1.3k 阅读

1 ·

CC 4.0 BY-SA版权

SQL & PL/SQL 专栏收录该内容

41 篇文章

订阅专栏

本文介绍如何使用DBMS_RANDOM.VALUE函数获取38位精度的随机数，并通过不同参数实现Oracle环境中的随机数生成，包括指定范围内的随机整数与浮点数。

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;

取得一组随机数：

select r             
from ( select rownum r from all_objects where rownum < 50 )
order by dbms_random.value;

select round(dbms_random.value(0,50)) from dual connect by level <=6;