Oracle 隨機取資料

Select *
From (
Select * From [tablename]
Order By dbms_random.random
)
Where Rownum <= 1;--看要取表列前幾筆

-----------------
產生亂數
select dbms_random.random from dual