-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
On Fri, Jun 08, 2001 at 03:58:26PM -0400, Steve Sapovits wrote:
>
> 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?
Use Oracle's DBMS_RANDOM PL/SQL package. This, surprisingly enough, Does What
You Want:
SELECT * FROM FOO ORDER BY DBMS_RANDOM.RANDOM();
Note that in < 8.1.7 you'll have to run $ORACLE_HOME/rdbms/admin/dbmsrand.sql as
SYS to create the package. In >= 8.1.7 it's installed by catproc.
You'll probably also want to call the DBMS_RANDOM.INITIALIZE() procedure
beforehand to seed the generator.
BEGIN
DBMS_RANDOM.INITIALIZE(1234567890)
END;
- --
Stephen Clouse <[EMAIL PROTECTED]>
Senior Programmer, IQ Coordinator Project Lead
The IQ Group, Inc. <http://www.theiqgroup.com/>
-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5.8
iQA/AwUBOyE3hgOGqGs0PadnEQIaCgCgk/uXDKBAt5NjQ8Ey1KjM3S+E8yIAn0MI
uKmSTLS5fxUv4UuTHZNXPPQx
=FlGt
-----END PGP SIGNATURE-----
