[code]
select *
from(
select * from tab
order by dbms_random.random
)
where rownum <10
[/code]