random order in Oracle?

[saloon12yrd]

Hi everybody,
I know this is not exactly what SQL was meant to do but is there a way to retrieve a result in a random order?
The statement would be like this:
SELECT id, shopid, [...] FROM products WHERE special_offer='Y' ORDER BY [random].

The ids are jagged so selecting an id at random and checking
a) whether such a product exists and
b) whether it is a special offer
would take too long.
Any ideas?

As always thanks in advance,

Dominique

[matto]

The best way (although a workaround) I see is:
in a first step select the ids where special_offer='Y', then, in the php script pick one random id and query the db for that record ...

// select ids into an array named $idlist

srand((double)microtime()*1000000);
$picked = $idlist[rand(0, count($idlist)-1];

// now select the record with id $picked