author:skate
time:2008/1/24
前天一个开发同事要得到一个表中的随机一条记录,这个就要用到oracle的dbms_random来实现这个功能
dbms_random(low value,high value)
eg:
select su.id from ( select id , rownum rn from s_user ) su
where su.rn = (select trunc(dbms_random.VALUE(1 , ( select count(1) from s_user ))) from dual )