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)
select length(sys_guid()),sys_guid() from dualselect * from ( select * from users order by sys_guid()) where rownum<10 ------------------------------------------------------------------selec