oracle通过sql随机取表中的10条记录:

SELECT * FROM (
SELECT * FROM T_USER ORDER BY DBMS_RANDOM.RANDOM()
) WHERE Rownum <= 10
;

05-11 08:01