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.

Report message to a moderator

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: 26766
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?

Report message to a moderator

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: 7901
Registered: March 2000
Senior Member
dbms_random

Report message to a moderator

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

Report message to a moderator

Previous Topic: Oracle Index
Next Topic: how to write the local procedure
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Feb 07 08:09:57 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.