Oracle生成大量的随机数

1、以sys用户登录SQL*Plus

sqlplus / as sysdba

2、执行语句

SCOTT@ ysdb1>select trunc(dbms_random.value * 1000000) as rmnum from dual connect by level < 100000;

3、查看结果