Hibernate version: 3.2.3
Name and version of the database you are using: Oracle 10.2

How to get randomly selected rows which matched the where clause from an oracle table using Hibernate ?

Is there a way to use Hibnerate to get random rows from the resultset.
Example: Table of size N records, out of which M matched my where clause and i want 10 random records out of M.

In MySql, we can do it by order by rand(), but could not find an alternative in Oracle.

Here it is..

SELECT column FROM
( SELECT column FROM table
ORDER BY dbms_random.value )
WHERE rownum = 1