1.select * from (select * from table order by dbms_random.value ) where rownum<=1 2.select * from (select * from table order by sys_guid() ) where rownum<=1