OraFAQ Forum: SQL & PL/SQL » How to generate RANDOM Number in Oracle

Home » SQL & PL/SQL » SQL & PL/SQL » How to generate RANDOM Number in Oracle

Mon, 04 February 2002 21:00

Biraja
Messages: 6
Registered: December 2000

Junior Member

Is there any function in Oracle to generate Random Numbers ?

Thanks!
Biraja

Tue, 05 February 2002 00:26

Random
Messages: 1
Registered: February 2002

Junior Member

This should do :

sys.dbms_random.value

Thu, 11 April 2002 03:14

Vijay
Messages: 116
Registered: September 1999

Senior Member

this will do to get 0 to 10
select round((sys.dbms_random.value*10)) from dual
with regards
vijay

Wed, 17 April 2002 20:20

Biraja
Messages: 6
Registered: December 2000

Junior Member

select dbms_random.value(2,3) from dual

Previous Topic:	Trigger Problem
Next Topic:	How to delete rows from multiple tables

Goto Forum:

]

Current Time: Wed Apr 24 01:42:17 CDT 2024