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: 64298
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: Tue Jan 24 14:05:22 CST 2017

Total time taken to generate the page: 0.17229 seconds