select length(sys_guid()),sys_guid() from dual
select * from
(
select * from users order by sys_guid()
)
where rownum<10
------------------------------------------------------------------
select dbms_random.value(1,10000) from dual
select * 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)
oracle 隨機取數據
最新推荐文章于 2022-06-30 11:06:53 发布