Re: Random Number generator in Oracle???

From: <info_at_revealnet.com>
Date: Tue, 23 Jun 1998 14:15:25 GMT
Message-ID: <6mod9t$dbv$1@nnrp1.dejanews.com>

Keith, try visiting the "Archives" section of the PL/SQL Pipeline. In it, you will find a free Random Number Generation Utility.

http://www.revealnet.com/pipeline.htm

The PL/SQL Pipeline is a free internet community for Oracle PL/SQL development hosted by author Steven Feuerstein and sponsored by RevealNet, Inc.

Best wishes,

Cam White
RevealNet, Inc.

In article <358EF049.18D_at_sol.co.uk>,
eoswa <eoswa_at_sol.co.uk> wrote:
>
> Hi there,
> I have a requirement to produce a report select in a random selection of
> records grouped by area - i.e. A report with 2 randomly chosen property
> records for each of the 450 areas in the database. Does anyone have any
> ideas on the best way to do this. I've considered using the SYSDATE as a
> seed for the random number generator but can't figure out the best way to
> proceed.
> Any help would be greatly appreciated.
> Thanks
> Keith Hill
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Jun 23 1998 - 09:15:25 CDT