1 2 Previous Next 23 Replies Latest reply: Jan 28, 2013 12:03 PM by Jonathan Lewis RSS

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

    986905
      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