Oracle function that generate random number

Reply-To: dschoen_at_lysis.ch
Distribution: worldwide

In the oracle distribution, it doesn t exist any function that generate random numbers.
I would like to define this function.
This function would then allow me to retrieve a random row. Something who look like

Select random_function (pass_in_variables) from table_name.

Does anyone know or already programmed a plsql function who do this ?

--
Dominique
dschoen_at_lysis.ch