Home » RDBMS Server » Server Administration » Query on random selection
Query on random selection [message #372353] Mon, 05 February 2001 02:31 Go to next message
Pavan Kumar
Messages: 10
Registered: October 2000
Junior Member
Hi all,
I am stuck with a small problem. The problem is something like this. I have a column question number in a database table. I need to dynamically/randomly select the quesiton number and select the corresponding question which is a varchar column of the same table. Can anyone help me in doing it ? Thanks in advance .

Pavan

Report message to a moderator

Re: Query on random selection [message #372366 is a reply to message #372353] Mon, 05 February 2001 12:08 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
You will probably find what you want in these 2 links. Based on the number of questions you have, you generate a random integer within that range e.g. 1-17

http://www.cs.umbc.edu/help/oracle8/network803/A54082_01/rndmnmbr.htm

http://osi.oracle.com/~tkyte/Misc/Random.html

Report message to a moderator

Previous Topic: Replication Software
Next Topic: Index - used/not used!
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed May 15 15:18:03 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.