oracle 取随机N条记录

明白了，应该
select * from(select * from table t order by DBMS_RANDOM.VALUE)where rownum<5
而不是
select * from table t
where rownum<5order by DBMS_RANDOM.VALUE