Home » SQL & PL/SQL » SQL & PL/SQL » Random....
Random.... [message #19009] Mon, 25 February 2002 21:46 Go to next message
Rajeev
Messages: 34
Registered: January 2000
Member
Is there any method by which we can get the result from a query in a random order, such that if the same query is applied the order should not be the same.
Re: Random.... [message #19025 is a reply to message #19009] Tue, 26 February 2002 08:13 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
If you are running 8i or higher, you can just:

order by dbms_random.random
Re: Random.... [message #19035 is a reply to message #19009] Tue, 26 February 2002 18:35 Go to previous messageGo to next message
Rajeev
Messages: 34
Registered: January 2000
Member
Hi,
I am not using the Oracle 8i. Is there any other method to get the random order.
Re: Random.... [message #19072 is a reply to message #19035] Wed, 27 February 2002 08:10 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
See the instructions here for generating random numbers in a 7.x environment:

http://osi.oracle.com/~tkyte/Misc/Random.html
Previous Topic: Is there something that represent empty but not null (like '' in MSSQL)?
Next Topic: Advanced SQL!!! Experts pls Help
Goto Forum:
  


Current Time: Thu Mar 28 21:29:07 CDT 2024