Re: Random Numbers

Derek,

This is easier than it seems. Use the square of sysdate (which includes miliseconds) and normalize the lower end to your desired range.

    select sysdate * sysdate rand_var from dual;

etc...

Defining a callable PL/SQL function makes it all easier, but that is your decision. You can also use SQL*Plus variables.

Derek Fielder wrote:

> 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