How to generate large random number with out decimal places ?
871594Nov 5 2012 — edited Nov 5 2012Hi ,
I need to generate random numbers from the range 71 million to 90 million. While generatind the same iam getting the value with decimal places.
How to generate with out decimal places ?
SQL> select ABS(dbms_random.value(71000000,90000000)) from dual;
ABS(DBMS_RANDOM.VALUE(71000000,90000000))
-----------------------------------------
87283730.7
Thanks,
Venkat Vadlamudi.