oracle取随机结果测试
oracle取随机结果测试
create table t as select * from all_objects where rownum <= 5000; select object_name, object_id from ( select object_name, object_id from t where object_name like '%%' order by dbms_random.random ) where rownum <= 4; select object_name, object_id from ( select object_name, object_id from t sample ( 1 ) where object_name like '%%' order by dbms_random.random ) where rownum <= 4; create table tt(ss number(10)); declare v_out number(3); i number(10); begin i := 1; while i <= 10000 loop begin insert into tt values(i); i := i + 1; end; end loop; --dbms_output.put_line(v_out); end; / commit; select dbms_random.random from dual; select * from (select * from tt order by dbms_random.random) where rownum<11;