1、生成1~100的顺序整数
select rownum from dual connect by 100>=rownum
2、生成1000个随机数
select rownum rn, dbms_random.value(0,1000) random from dual connect by rownum<=1000;
1、生成1~100的顺序整数
select rownum from dual connect by 100>=rownum
2、生成1000个随机数
select rownum rn, dbms_random.value(0,1000) random from dual connect by rownum<=1000;