Hello,
The title says it!
Many thanks...
| SitePoint Sponsor |
Hello,
The title says it!
Many thanks...
Why It Doesn't Work?!


select * from t where rownum=1 order by dbms_random.value
or something like that![]()
Thanks but the following didn't work for me:
I am getting the last row in the table!Code:select TEXT AS PROMOWORD from PROMO_WORDS where rownum=1 order by dbms_random.value
Please advise.
Why It Doesn't Work?!


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
Try using dbms_random.random
What version of Oracle are you running?
ssegraves [at] gmail.com
On Image Use, Abuse, and Where We're Headed
stephan | XMLHttpRequest Basics
flickr | last.fm | Cogentas, LLC
Bookmarks