Re: RANDOM

From: Peter A Fein <p-fein_at_uchicago.edu>
Date: 1998/09/09
Message-ID: <opgbtopui7a.fsf_at_harper.uchicago.edu>#1/1


"Arjan van Bentem" <avbentem_at_DONT-YOU-DAREdds.nl> writes:

>
> >RANDOM in the order by..
>
>
> I just learned this trick some time ago:
>
> select *
> from emp
> order by dbms_utility.get_hash_value( dump( rowid ), 0, 1000);

Not truly random, or even truly pseudorandom, but probably close enough. ;)

-- 
Peter A Fein                                           Summering in SF!
Home: 650-571-6476                                   Work: 650-628-2172
p-fein_at_uchicago.edu                             pfein_at_us.checkpoint.com
Who's going to pay for this!?!
Received on Wed Sep 09 1998 - 00:00:00 CEST

Original text of this message