解析：教你轻松掌握随机抽取记录的方法

create table t as select * from all_objects where rownum <= 5000;set timing onselect object_name, object_idfrom ( select object_name, object_idfrom twhere object_name like '%%'order by dbms_random.random )where rownum <= 6;select object_name, object_idfrom ( select object_name, object_idfrom t sample ( 1 )where object_name like '%%'order by dbms_random.random )where rownum <= 6;