随机返回5条记录select * from (select * from emp order by dbms_random.value()) where rownum5??调用
随机返回5条记录
select * from (select * from emp order by dbms_random.value()) where rownum<=5
?
?
调用了dbms_random.value()函数
随机回来5条记录
2012-09-24
随机返回5条记录
select * from (select * from emp order by dbms_random.value()) where rownum<=5
?
?
调用了dbms_random.value()函数