从表中随机取一条数据 select * from (select * from tab order by dbms_random.value) where rownum=1 ; 出处 http://javas.blog.51cto.com/2153666/457485