OraFAQ Forum: Server Administration » Query on random selection

Home » RDBMS Server » Server Administration » Query on random selection

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query on random selection [message #372353]

Mon, 05 February 2001 02:31

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

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 10:23:20 CST 2025