Hi,

Package for random number generation - DBMS_RANDOM generates same number each time I execute it - taking the same seed value. Following is the piece of code:

dbms_random.seed( 1 ) ;
rh := dbms_random.value(0, 10) ;
rm := dbms_random.value(1, 100) ;
dbms_random.terminate() ;

Is it required to take a different seed value each time I execute it ????

And ... what all procedures/functions are included in this package ??

Thanks in advance ....