从表中随机回来n条记录

CREATE OR REPLACE VIEW V ASSELECT 'a' AS c FROM dualUNION ALLSELECT 'b' AS c FROM dualUNION ALLSELECT 'c' AS c FROM dualUNION ALLSELECT 'd' AS c FROM dualUNION ALLSELECT 'e' AS c FROM dual;SELECT * FROM v;

SELECT c  FROM (SELECT c FROM v ORDER BY DBMS_RANDOM.VALUE()) WHERE ROWNUM < 3;