Re: RANDOM
From: Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl>
Date: 1998/09/09
Message-ID: <6t6lv6$la8$1_at_newton.a2000.nl>#1/1
Date: 1998/09/09
Message-ID: <6t6lv6$la8$1_at_newton.a2000.nl>#1/1
>RANDOM in the order by..
[Quoted] I just learned this trick some time ago:
select *
from emp
order by dbms_utility.get_hash_value( dump( rowid ), 0, 1000);
Alternatively, get the Rand function at
http://www.oracle.com/st/products/features/free_plsql_utilities.html
select *
from emp
order by Rand;
Arjan. Received on Wed Sep 09 1998 - 00:00:00 CEST