Oracle Database Discussions

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