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: 65155
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: USING OBJECT TYPE WITH BULK COLLECT
Next Topic: different results
Goto Forum:
  


Current Time: Wed Aug 23 22:11:04 CDT 2017

Total time taken to generate the page: 0.07817 seconds