[thesite] t.e.o. updates

[rudy]

> do you have any suggestions for how i can query it once for each row

you're talking about
http://www.orafaq.com/msgboard/tools/messages/2146.htm, right?

frankly, i have no idea about oracle packages, however, if you can query it
from dual then i don't see why you couldn't query it from some other table
and expect it to get (re)evaluated for each row...

yup, i was right, here ya go --

SQL> select categoryid, rand.random from categorys;

CATEGORYID     RANDOM
---------- ----------
         1 .884901581
      4090 .328118896
      4091 .460609436
        12 .124318085
        17 .153736572
        18 .746638153
        20 .936595215
        21 .533955688
        22 .401109344
        23 .119030762
        25 .110170898
        26 .312037659
      9741 .091429535
     10047 .808234558

14 rows selected.



so just plunk rand.random*1000000000 as randum (or whatever) into the
SELECT list of the outer query and you're good to go


rudy