学步园

使用ORDER BY子句，ROWNUM内置函数和DBMS_RANDOM包中的内置函数VALUE来实现

SQL> select * from<br /> 2 (<br /> 3 select ename,job<br /> 4 from emp<br /> 5 order by dbms_random.value()<br /> 6 )<br /> 7 where rownum<=5;</p> <p>ENAME JOB<br /> ---------- ---------<br /> TURNER SALESMAN<br /> SMITH CLERK<br /> MARTIN SALESMAN<br /> BLAKE MANAGER<br /> SCOTT ANALYST</p> <p>SQL> /</p> <p>ENAME JOB<br /> ---------- ---------<br /> ALLEN SALESMAN<br /> SMITH CLERK<br /> WARD SALESMAN<br /> MARTIN SALESMAN<br /> SCOTT ANALYST