This discussion is archived
1 2 Previous Next 23 Replies Latest reply: Jan 28, 2013 10:03 AM by Jonathan Lewis RSS

What is the possibility of getting the same random number repeated again?

986905 Newbie
Currently Being Moderated
I would like to generate a 5 digit random number;

select round(dbms_random.value(10, 999990)) from dual;

The above query seems good enough but what is the possibility of getting the same random number repeated again? I am fine with repetition as long as it does not repeat within a second. Is there any such guarantee?

Thanks
Venkatesh
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points