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.
取得一个随机数
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;