oracle 随机获取表中记录

select *
  from (select rownum, c.empno, c.ename, c.job
          from (select * from scott.emp order by dbms_random.value) c
         where rownum <= 6);

随机获取前六条