Re: Random Numbers

From: Mike Quist <mquist_at_concentric.net>
Date: 1997/09/23
Message-ID: <34289ABD.6AE6@concentric.net>#1/1

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

Derek,
A new book "Oracle & UNIX Performance Tuning", Ahmed Alomari, published by Prentice Hall includes a CD-ROM that has a script to create a stored procedure for generating random #'s. It may be what you need? Mike Received on Tue Sep 23 1997 - 00:00:00 CDT