[thesite] t.e.o. updates
rudy
r937 at interlog.com
Sat Nov 17 13:48:30 CST 2001
> 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
More information about the thesite
mailing list