1 SELECT A.* FROM TableA A CROSS JOIN (SELECT TRUNC(DBMS_RANDOM.VALUE(0,  999999999999999999999)) RANDOMNUM FROM DUAL) B ORDER BY B.RANDOMNUM