1 SELECT A.* FROM TableA A CROSS JOIN (SELECT TRUNC(DBMS_RANDOM.VALUE(0, 999999999999999999999)) RANDOMNUM FROM DUAL) B ORDER BY B.RANDOMNUM
Oracle随机获取记录,布布扣,bubuko.com
Oracle随机获取记录
原文：http://www.cnblogs.com/yomho/p/3745065.html
