Retrieve records randomally

Hi all,

is there a possibillity to retrieve a numer of records randomally from a table ?
I have a table with 300000 records an want to retrieve a user-defined percentage
of random selected records.
I know that i can use a column, update the whole table with distinct random-numbers
and than retrieve all records < x.

But i think there should be another solution without updating a column.

Maybe something with random rowid´s ?

Thanks in advance
U.Kaemmerer

++++++++++++++++++++++++++++++++++

Ulrich Kämmerer
Creon IT Consult GmbH

Tel   : +49 69 609004-11
Fax   : +49 69 609004-20
Mobil : 0171 / 2837367
EMail : U.Kaemmerer_at_Creon-IT.com


++++++++++++++++++++++++++++++++++