select *
from (select rownum, c.empno, c.ename, c.job
from (select * from scott.emp order by dbms_random.value) c
where rownum <= 6);
随机获取前六条
select *
from (select rownum, c.empno, c.ename, c.job
from (select * from scott.emp order by dbms_random.value) c
where rownum <= 6);