SQL> select * from (select ename,job from emp order by dbms_random.value() ) where rownum <5
2 ; ENAME JOB
---------- ---------
WARD SALESMAN
JAMES CLERK
BLAKE MANAGER
KING PRESIDENT SQL> / ENAME JOB
---------- ---------
TURNER SALESMAN
CLARK MANAGER
SMITH CLERK
WARD SALESMAN SQL> / ENAME JOB
---------- ---------
SCOTT ANALYST
KING PRESIDENT
SMITH CLERK
CLARK MANAGER SQL> / ENAME JOB
---------- ---------
SCOTT ANALYST
JAMES CLERK
JONES MANAGER
SMITH CLERK