Home » SQL & PL/SQL » SQL & PL/SQL » Hi Everyone (Randomly)
Hi Everyone [message #332534] Tue, 08 July 2008 19:41 Go to next message
art_ora
Messages: 10
Registered: May 2008
Junior Member
Hello,

Can you help me to find a solution for having a program to randomly selected of integer. I want to create a program that i randomly selected a number for this number will become a winner number.

How can I program that?

Thanks, more power to you.
Re: Hi Everyone [message #332535 is a reply to message #332534] Tue, 08 July 2008 19:45 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


What does this problem have to do with Oracle?
This is a classic Programming 101 problem.

Is GOOGLE broken for you?
Re: Hi Everyone [message #332543 is a reply to message #332534] Tue, 08 July 2008 23:08 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
dbms_random
Re: Hi Everyone [message #332562 is a reply to message #332534] Wed, 09 July 2008 00:23 Go to previous message
adit_me1
Messages: 49
Registered: October 2007
Location: BANGALORE
Member
round(dbms_random.value(#v1,#v2))


will give you random whole numbers in the range of v1 and v2
Previous Topic: Oracle Index
Next Topic: how to write the local procedure
Goto Forum:
  


Current Time: Fri Dec 09 21:40:31 CST 2016

Total time taken to generate the page: 0.06091 seconds