Re: Order by

"Tony Andrews" <[email protected]> Tue, 11 Feb 2003 12:40:04

Newsgroups	gmane.comp.db.oracle.devel
Message-ID	<LYRIS-1796914-869691-2003.02.11-12.24.59--gcdod-oracle#[email protected]>

It looks like you want the records in a random order?
You can do this:

select *
from table
order by dbms_random.value;

---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].