ordering record randomly.

From: Nabanita <nabanita_chat_at_hotmail.com>
Date: 15 Nov 2001 11:59:31 -0800
Message-ID: <9811bb34.0111151159.6d86f0db_at_posting.google.com>

Can anyone please tell me how to order records from a table in oracle randomly?
I mean, say, there is a table containing user entries. I want a recordsset which contains these entries randomly ordered. I need this for choosing random winner on fly for sweepstakes.. Received on Thu Nov 15 2001 - 20:59:31 CET

This message: [ Message body ]
Next message: John Lawless: "Trouble with SSH and Oracle SQL Plus Connections"
Previous message: Liam: "SQL*Net being used over Net8"
Next in thread: Francois Lotter: "Re: ordering record randomly."
Reply: Francois Lotter: "Re: ordering record randomly."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message