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
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: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You give the end points you want to dbms_random.value function, so give it 0 at minimum.

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


Current Time: Sat Dec 10 14:34:55 CST 2016

Total time taken to generate the page: 0.12318 seconds