Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: RANDOM
"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 CDT