dbms_random

• 1、取随机数

--取任意大小随机整数 -power(2,31) <= random < power(2,31)
select dbms_random.random from dual;

--取随机小数 0.0 <= value < 1.0
select dbms_random.value from dual;

--取1-100随机数 1 <= value < 100
select dbms_random.value(1, 100) from dual;

--取1-100随机整数 1 <= value < 100
select trunc(dbms_random.value(1, 100)) from dual

• 2、取随机记录

with temp0 as(
  select * 
    from system_user 
   order by dbms_random.random
) 
select * 
  from temp0
 where rownum <= 10;

• 3、取随机字符串

select dbms_random.string('U', '5') from dual;