Generate random numbers in PL/SQL, any good ways? Is there an internal?
From: Hans Lindberg <d7hansl_at_dtek.chalmers.se>
Date: 12 Jul 94 12:41:03 GMT
Message-ID: <d7hansl.774016863_at_dtek.chalmers.se>
Date: 12 Jul 94 12:41:03 GMT
Message-ID: <d7hansl.774016863_at_dtek.chalmers.se>
Hi!
I'm looking for a way to generate test data with certain probabilities
for the different values of the data. I can't find any random number
generator in neither the SQL ref man nor the PL/SQL ditto. Am I missing
the obvious or isn't there any? Do I have to implement a my own random
function? In that case, anyone know of a decent one? Nothing super, just
so it looks fairly randomuous(?). I remember something called 147-something
but i can't remember how it went.
Hans Lindberg Tel: 031-183151 EMail d7hansl_at_dtek.chalmers.se Gullspaangs Kraft AB
/ / / "-Fashion is a form of ugliness so intolerable
/ / / that we have to alter it every six months."
/------/ /
/ / / --Oscar Wilde
/ / /.....
---------------------------------------------------------------------------
Received on Tue Jul 12 1994 - 14:41:03 CEST