Does any know of a way, either directly through Oracle
using SQL, or in conjunction with DBI to have rows returned
in a random order? The problem to solve is this: We fetch
similar result sets across several queries, but we want the
resulting output order to be different.
The data sets are large, so randomizing in memory is not a
viable option. I'd like to just affect the fetch somehow.
Rewriting the query in PL/SQL is also not desired.
It would seem that if I could get at the underlying result set
before the first fetch I could do something here ... but that
seems like a real violation of interface.
----
Steve Sapovits
Global Sports Interactive
Work Email: [EMAIL PROTECTED]
Home Email: [EMAIL PROTECTED]
Work Phone: 610-491-7087
Cell: 610-574-7706
Pager: 877-239-4003
