Re: random numbers in PL/SQL ?

In article <5arceq$h4i_at_ratatosk.uio.no>,   kjetil.skotheim_at_usit.uio.no (Kjetil Skotheim) wrote:
>
>
> are there any random number generator in PL/SQL or oracle ?

I have a random number generator written in PL/SQL at

  http://ourworld.compuserve.com/homepages/bob_jenkins/rnd.sql

In the case where you can't use it (the where clause of select statements), in v7.2 or later the dbms_utility package has a hash function (get_hash_value, I think) that you can pass the current row's rowid.

• Bob Jenkins bob_jenkins_at_compuserve.com

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet