创建测试用表：
|
1
2
3
4
5
6
7
8
9
10
11
|
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; |
查询语句如下：
|
1
2
3
|
SELECT c FROM (SELECT c FROM v ORDER BY DBMS_RANDOM.VALUE()) WHERE ROWNUM < 3; |
查询结果如下：
原文：http://www.cnblogs.com/mengyuxin/p/4889720.html