How do I select a random set of records in Oracle?
I MS SQL6 I just set the ROWCOUNT to the number of
records I want and do a select with ORDER BY
RAND(). Is there any Oracle equivilent.
Does anyone know the best way to select a record from oracle randomly.
The reason I ask, is that I am developing a dictionary of terms related
to GIS that can be accessed via the WWW. What I would like to do, is have
some method for the user to press, say a button labelled 'random' on the
form, and a random term and its related definition to be returned. The
dictionary will have approximately 1500 terms, and ideally, only one of
these would be returned by this function. Not knowing a great deal about
PL/SQL, is there a way to do this using SQL, or will I have to get my