
ORACLE随机查询n条记录
方法一:通过dbms_random.random select * from (select * from your_table order by dbms_random.random) where rownum < 1000; 方法二:通过dbms_random.value select * from (select * from your_table order by dbms_random.value) where rownum < 1000; 方法三:通过采样表扫描 select * f