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;