[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


More information about the thesite mailing list