[thesite] t.e.o. updates
rudy
r937 at interlog.com
Sat Nov 17 07:24:40 CST 2001
> rudy, can you tell me why this silly
> query always returns the same number
> for the rank alias? is it because the
> subselect is run first and its result
> is tacked onto each row the main query
> returns?
>
> , (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
rudy
More information about the thesite
mailing list