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

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?


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: 63924
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.

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

Current Time: Wed Oct 26 08:59:45 CDT 2016

Total time taken to generate the page: 0.14936 seconds