[오라클] 랜덤 추출

order by DBMS_RANDOM.RANDOM

where rownum < 2 --랜덤하게 추출할 row 수

SELECT
	*
FROM
	(
    SELECT * FROM "테이블" ORDER BY DBMS_RANDOM.RANDOM
    )
WHERE
	ROWNUM <= 1