Home > Oracle > Generador de numeros

Generador de numeros

27 January, 2007 Leave a comment Go to comments
Antes habia visto como generar datos dummy.
Esta opción de generar numeros esta interesante.
http://oracledba.co.uk/

sys@DBA> select rownum from dual connect by rownum <=10;

ROWNUM
----------
1
2
3
4
5
6
7
8
9
10

10 rows selected.

sys@DBA> select dbms_random.value from dual connect by rownum <=10;

VALUE
----------
.876879822
.04653477
.592060427
.273758898
.488285804
.523971849
.717315039
.092101034
.598717486
.99935022

10 rows selected.

10 rows selected.


Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.