oracle随机取n条记要

oracle随机取n条记录
oracle随机取n条记录

select * from (select * from table order by dbms_random.value ) where rownum < n 

select * from (select * from (select a1.*,rownum rn from (select * from table) a1 where rownum<=4) where rn>=2 order by dbms_random.value ) where rownum < 2;