› Fóruns › SQL e PL/SQL › DBMS_UTILITY. GET_HASH_VALUE › DBMS_UTILITY. GET_HASH_VALUE
18 de setembro de 2009 às 1:32 pm
#89765
ramasineParticipante
Veja se é isso!
SELECT * FROM
(SELECT * FROM EMP
ORDER BY DBMS_UTILITY.GET_HASH_VALUE(TO_CHAR(dbms_utility.get_time)||ename,2,1048576))
WHERE ROWNUM /
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
7566 JONES MANAGER 7839 02-APR-81 2975 20
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30