How can I get a random record from my oracle table?

[Angry Coder]

Hello,

The title says it!

Many thanks...

[r937]

select * from t where rownum=1 order by dbms_random.value

or something like that

[Angry Coder]

Thanks but the following didn't work for me:

select TEXT AS PROMOWORD from PROMO_WORDS where rownum=1 order by dbms_random.value

I am getting the last row in the table!

Please advise.

[r937]

i wish i had oracle to test this out for you

well, if no one else jumps into this thread, i'm afraid you have no choice but to visit google with phrases like "random row +oracle" or "dbms_random.value +oracle"

sorry

[Hartmann]

Try using dbms_random.random

What version of Oracle are you running?