Oracle function that generate random number

From: Dominique Schoenenberger <dschoen_at_lysis.ch>
Date: Tue, 7 Feb 1995 10:18:16 GMT
Message-ID: <D3MKMI.n53_at_eunet.ch>


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
Received on Tue Feb 07 1995 - 11:18:16 CET

Original text of this message