DBMS_RANDOM generates same number .... !!!!

[Pinakin]

Hi,

Try executing the following script :

/* Begin */
BEGIN
DECLARE
r1 NUMBER ;
r2 NUMBER ;
BEGIN
BEGIN
dbms_random.seed( 1234567890 ) ;
r1 := dbms_random.random() ;
r2 := dbms_random.random() ;
dbms_random.terminate() ;
DBMS_OUTPUT.PUT_LINE('R1 : '||r1|| ' R2 : '|| r2 ) ;
END ;
BEGIN
dbms_random.seed( 1234567890 ) ;
r1 := dbms_random.random() ;
r2 := dbms_random.random() ;
dbms_random.terminate() ;
DBMS_OUTPUT.PUT_LINE('R11 : '||r1|| ' R12 : '|| r2 ) ;
END ;
END ;
END ;
/* End */

Try on two different instances of SQL and check out the o/p.

Well, I used SYSDate and had my work done ...

Regards,
Pinakin.