Home » SQL & PL/SQL » SQL & PL/SQL » How to generate random positive numbers? (Oracle 10.2.0.3)
How to generate random positive numbers? [message #348094] Mon, 15 September 2008 10:52 Go to next message
hedonist123
Messages: 119
Registered: August 2007
Senior Member
Hi,

I am aware of the dbms.random package which is used to generate random numbers.

However, I wish to obtain only positive numbers from this package.

Are there any parameters that have to be set for its use to obtain positive numbers only?

Thanks,

Sharath

Report message to a moderator

Re: How to generate random positive numbers? [message #348097 is a reply to message #348094] Mon, 15 September 2008 10:58 Go to previous message
Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You give the end points you want to dbms_random.value function, so give it 0 at minimum.

Regards
Michel

Report message to a moderator

Previous Topic: SQL Query help
Next Topic: Row to Column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Jul 16 13:26:26 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.