[thesite] t.e.o. updates
.jeff
jeff at members.evolt.org
Sat Nov 17 13:34:29 CST 2001
rudy,
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
> From: rudy
>
> > , (SELECT rand.random * 100000000
> > FROM dual
> > ) AS rank
>
> yup, that would explain it
>
> i haven't used oracle's random number generator but
> your interpretation of it being run only once and the
> result used on each row of the outer query sounds like
> the answer
><><><><><><><><><><><><><><><><><><><><><><><><><><><><><
oracle doesn't have a built-in random number generator so i had to have the
stored procedure added. keeping in mind that it must be queried like the
above (doesn't need the * 100000000 bit though), do you have any suggestions
for how i can query it once for each row thereby giving each row a randomly
generated number?
thanks,
.jeff
http://evolt.org/
jeff at members.evolt.org
http://members.evolt.org/jeff/
More information about the thesite
mailing list