jeudi 23 avril 2015

generate random 0 or 1 - Oracle

I need to generate a random value that can be 0 or 1. I tried this: select floor(DBMS_RANDOM.VALUE (0, 1)) from dual but there is a very very very low possibility of get value 1. Is there any chance to get this where the possibilities for 0 and 1 are similar?




Aucun commentaire:

Enregistrer un commentaire