Re: Random sample

From: <nasof_at_my-dejanews.com>
Date: Fri, 10 Jul 1998 18:02:35 GMT
Message-ID: <6o5kvr$r2h$1@nnrp1.dejanews.com>

You can find out about random number at: http://www.oracle.com/st/products/features/random_down1.html

Why don't you try to generate a random number based on the count(*) of the table you are querying and then fetch through that cursor until you reach that number.

PLSQL Might go something like:

DECLARE
cursor table_cursor is

        select * from MY_TABLE;
    random_row table_cursor%ROWTYPE;
BEGIN
    select count(*) into the_count
    from MY_TABLE;

PSEUDO RND NUMBER select round(abs(sin(to_char(sysdate,'ssmihh24')))*the_count) into random_number from dual;

open table_cursor;
For i in 1..the_count loop

fetch table_cursor into random_row; end loop;

Process random_row...

END; -Frank

In article <35A61AF4.B7C981AF_at_neurotec.de>, Stefan Schmitz <sts_at_neurotec.de> wrote:
> Hi,
>
> I'm looking for an easy method (perhaps in PL/SQL) to draw a random
> sample from a oracle table.
>
> Regards,
> Stefan
>
> --
> Dipl.-Inform. Stefan Schmitz
> NEUROTEC Hochtechnologie GmbH
> Intelligente Systeme
> Ehlerstrasse 15
> 88046 Friedrichshafen
>
> Tel. +49-7541-3012-151
> Email sts_at_neurotec.de
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Jul 10 1998 - 13:02:35 CDT