select * from (select rownum,KEYWORD, CATEGORY,CREATE_DATE,UPDATE_DATE from (select * from knet_keyword_category_t where category=‘two‘) order by dbms_random.value) where rownum<=10346;
select * from (select rownum,phone,create_time from tmp_Test order by dbms_random.value) where rownum<=50;
原文：http://www.cnblogs.com/feiyun126/p/4270398.html