随机返回5条记录

select * from (select * from emp order by dbms_random.value()) where rownum<=5

?

?

调用了dbms_random.value()函数