ORACLE随机取记录

oracle随机取数据，通过随机函数包dbms_random，按随机排序实现，如下

随机取几条记录
--方法一
select * from (select * from t_sms_game_down t order by dbms_random.value) where rownum <5; 
--方法二
select * from (select * from t_sms_game_down t order by sys_guid()) where rownum <5;

 

select trunc(dbms_random.value(100,200)) from dual;  --生成100和200之间的随机数，trunc取整