使用ORDER BY子句,ROWNUM内置函数和DBMS_RANDOM包中的内置函数VALUE来实现 SQL> select * from 2 ( 3 select ename,job 4 from emp 5 order by dbms_random.value() 6 ) 7 where rownum<=5; ENAME JOB ---------- --------- TURNER SALESMAN SMITH CLERK MARTIN SALESMAN BLAKE MANAGER SCOTT ANALYST SQL> / ENAME JOB ---------- --------- ALLEN SALESMAN SMITH CLERK WARD SALESMAN MARTIN SALESMAN SCOTT ANALYST