oracle 隨機取數據
来源：互联网 发布：avmask永久域名 编辑：程序博客网 时间：2024/06/06 02:39
select length(sys_guid()),sys_guid() from dualselect * from ( select * from users order by sys_guid()) where rownum<10 ------------------------------------------------------------------select dbms_random.value(1,10000) from dualselect * from ( select * from users order by dbms_random.value(1,10000)) where rownum<10---------------------------------------------------------------------select dbms_random.random() from dual;select * from ( select * from users order by dbms_random.random) where rownum<10--------------------------------------------------------------------------select * from users sample(0.1)
