Re: RANDOM

>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);

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 CDT