Random Numbers

Does anyone know of a way of generating random or semi-random numbers in PL/SQL? I have a client who has two requirements 1. They would like to select random records from a table. 2. They would like to select records based on randomly selected dates within a range.

The first requirement can probably be met by sorting on some strange combination of fields but the second one seems to require a random number generator.

Any ideas?

dfielder_at_usa.net Received on Thu Sep 18 1997 - 00:00:00 CDT