select a random sample of results from an oracle query

Question

This question asks about getting a random(ish) sample of records on sqlserver and the answer was to use "TABLESAMPLE", is there an equivalent in Oracle 10?

If there isn't is there a standard way to get a random sample of results from a query set. For example to get 1000 random rows from a query that will return Millions normally.

Answer 1

SELECT  *
FROM    (
        SELECT  *
        FROM    mytable
        ORDER BY
                dbms_random.value
        )
WHERE rownum <= 1000

Answer 2

There is also a special sample clause to select a percentage: http://oracleact.com/papers/sampleclause.html