OraFAQ Forum: Server Administration

Wed, 04 April 2001 10:08

Bobby
Messages: 32
Registered: August 2000

Member

How do i generate a random number in oracle?

Wed, 04 April 2001 12:37

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

select t1.*, random.rand
from t1
order by 2

Random package may be retrieved from:
http://osi.oracle.com/~tkyte/Misc/Random.html

Previous Topic:	Cooment in Table
Next Topic:	help?

Goto Forum:

]

Current Time: Mon Dec 23 05:37:47 CST 2024