posted 16 years ago
if you dont want to use any built in function then try this formula
Random no R(n) = (aR(n-1) + b)mod n where a = any initial value , b= any offset and R is the previous Random no ,keep R(n-1)=1 for the first case.It is also known as Linear congruential Generator .Check out Wikipedia for a detailed explanation.
Enjoy, Chander
SCJP 5, Oracle Certified PL/SQL Developer