Re: Random number in Oracle
From: Miki Mike <malderhout_at_yahoo.com>
Date: Fri, 16 Feb 2001 12:15:57 -0000
Message-ID: <h18j6.5$Mq2.612_at_psinet-eu-nl>
Date: Fri, 16 Feb 2001 12:15:57 -0000
Message-ID: <h18j6.5$Mq2.612_at_psinet-eu-nl>
Michette,
There is as far I know not function in Oracle.
Use something like select to_number(TO_CHAR(SYSDATE,'SSSSS')) from dual (this is not really random)
Or use a sequence and multiply/divide it with something. (of course this is'nt really random too)
Greet,
Miki Mike
Michetti Fabio <michettif_at_bpn.it> wrote in message
news:96irdc$qnd$1_at_fe1.cs.interbusiness.it...
> Can I generate a Random number in Oracle ?
>
> Is there a function ?
>
> Thanks
> Fabio from Italy
>
>
>
>
Received on Fri Feb 16 2001 - 13:15:57 CET